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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!