As an Oracle database administrator, write statements to:

a) create a role named emp_role, which will have the privileges to . connect to the database query a table Tl owned by user HR create its own tables 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 create a password verification function pass_verify to enforce a password to conform to all the following rules c) . contains at least 8 characters contains at least one letter and at least one digit starts with a upper-case letter does not contain the username as a substring d) create the user Ellie using password Eabc000, 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) a) create a role named emp_role, which will have the privileges to . connect to the database query a table Tl owned by user HR create its own tables 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 create a password verification function pass_verify to enforce a password to conform to all the following rules c) . contains at least 8 characters contains at least one letter and at least one digit starts with a upper-case letter does not contain the username as a substring d) create the user Ellie using password Eabc000, 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)