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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started