Question: database pl/sql Create three users : usr1, usr2 and usr3: a. Usr1 and usr2 belong to a role named hr. In this role, users can
database pl/sql
Create three users : usr1, usr2 and usr3: a. Usr1 and usr2 belong to a role named hr. In this role, users can execute all procedures and functions in the package but cannot read and modify the content of the three tables.
Usr1 and usr2 belong to a role named hr. In this role, users can execute all procedures and functions in the package but cannot read and modify the content of the three tables. b. Usr3 can only update the cust_mobile in the table customer. He can also give his privileges to other users
this is the tables
1-Account: account_id, cust_id,amount,creation_date ?
2-Customer:cust_id,cust_name,cust_mobile,cust_birthdate ?
3-Employee: emp_id,emp_name,emp_salary
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
