Assume an Oracle database administrator has connected to a pluggable database. What will be the statements the DBA use to a) create a role named emp_role, which will have the privileges to connect to the database, query a table T1 owned by user HR create tables in a user's own schema b) create a profile named emp_profile to limit database resource consumption and enforce password policy as follows: • logon time should be at most 5 hours idle time should be at most 20 minutes CPU time required per call should be at most 1 second at most 10 data blocks can be read per session a password must expire every 30 days at most three successive failed login attempts are allowed a password cannot be reused c) create a password verification function emp_pass_verify to enforce a password to conform to all the following rules: contains at least 8 characters contains at least one letter, at least one digit, and at least one special character (that is not a letter or a digit) starts with an upper-case letter does not contain the username as a substring d) create a user Hw4User using password Hw4000, according to the following • guidelines: • the default tablespace is TOOLS the temporary tablespace is TEMP_TOOL_GROUP the account is initially locked the user account will be assigned with emp_profile profile has a 10MB quota in the TOOLS tablespace the user is granted with role emp_role the user's password should be verified using the rules specified in problem c)

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Transcribed Image Text:Assume an Oracle database administrator has connected to a pluggable database. What will be the statements the DBA use to a) create a role named emp_role, which will have the privileges to connect to the database, query a table T1 owned by user HR create tables in a user's own schema b) create a profile named emp_profile to limit database resource consumption and enforce password policy as follows: logon time should be at most 5 hours idle time should be at most 20 minutes CPU time required per call should be at most 1 second at most 10 data blocks can be read per session a password must expire every 30 days at most three successive failed login attempts are allowed a password cannot be reused c) create a password verification function emp_pass_verify to enforce a password to conform to all the following rules: contains at least 8 characters contains at least one letter, at least one digit, and at least one special character (that is not a letter or a digit) starts with an upper-case letter does not contain the username as a substring d) create a user Hw4User using password Hw4000, according to the following guidelines: the default tablespace is TOOLS the temporary tablespace is TEMP_TOOL_GROUP the account is initially locked the user account will be assigned with emp_profile profile has a 10MB quota in the TOOLS tablespace the user is granted with role emp_role the user's password should be verified using the rules specified in problem c)

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions