Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

with admin option

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

Related Posts Plugin for WordPress, Blogger...

Flag Counter