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