I really need help with this assignment with step by step instructions on how to
ID: 3803884 • Letter: I
Question
I really need help with this assignment with step by step instructions on how to complete it.
Using SQL Developer and SQL Plus
1. Create role customer_entry
2. Grant role customer_entry permission to update OE.CUSTOMERS table
3. Add user1 to the role customer_entry 12. Check permissions you granted by using data dictionary view
4. Check permissions you granted by using user1 account to update OE.CUSTOMERS table.
5. What procedures would you follow if you were told that an employee was terminated?
Please and thank you
Explanation / Answer
1.
Create Role customer_entry identified by cutomer123;
customer123 is password
2.
Grant update on OE.CUSTOMERS to customer_entry;
Assign update permission to the role customer_entry.
3.
Grant customer_entry to user1;
grant customer_entry role to the user user1.
4.
Show Grants for user1;
Show all permissions granted to user1;
5.
Create user 'employee' identified by 'password';
Drop user 'employee' ;
delete user employee.