SQL> desc dba_tables;
To list which tables have permissions to which users.
SQL> select table_name from dba_tables where owner='SCOTT';
SQL> select owner,table_name from dba_tables where owner='SCOTT';
SQL> grant create session to venu with admin option;
SQL> desc dba_sys_privs;
SQL> select * from dba_sys_privs where grantee='VENU';
SQL> conn venu/venu
venu> grant create session to venu1;
venu> conn venu1/venu1
venu1> conn / as sysdba
SQL> revoke create session from venu;
SQL> conn venu/venu
ORA-01045 : user 'VENU' lacks create session privilege : login denied
SQL> conn / as sysdba
SQL> conn venu1/venu1
venu1> conn / as sysdba
No comments:
Post a Comment