SQL> conn venu/venu
venu> select * from scott.dept;
ORA-00942 : table or view does not exist
venu> conn scott/tiger
scott> grant select on dept to venu with grant option;
scott> conn venu/venu
venu> select * from scott.dept;
venu> grant select on scott.dept to venu1;
venu> conn venu1/venu1
venu1> select * from scott.dept;
venu1>conn scott/tiger
scott> revoke select on dept from venu;
scott> conn venu/venu
venu> select * from scott.dept;
ORA-00942 : table or view does not exist.
venu> conn venu1/venu1
venu1> select * from scott.dept;
ORA-00942 : table or view does not exist.
No comments:
Post a Comment