Tuesday, September 19, 2023

SQL LABS - Privileges

Privileges  


1)Create Two Users:

-> Create Duplicate table of emp1 from emp;
-> User1 should insert ,select,delete from scott.emp1
-> User2 should insert ,select,delete from scott.emp1;

2) check the system and object privilages for all users(scott, user1,user2);

3) from user1 if i give select * from emp1 data should come from scott.emp1
this emp1 user1 should be used all other users;

No comments:

Post a Comment