Search This Blog

Saturday, February 24, 2007

Privilege

What is Role granted to USER/SCHEMA.

SQL> select GRANTED_ROLE from dba_role_privs where grantee = '&USERNAME';


What is Privilege granted to USER/SCHEMA.

SQL> select PRIVILEGE from dba_sys_privs where grantee = '&USERNAME';


What is Privilege on table.

SQL> select TABLE_NAME,PRIVILEGE
2 from dba_tab_privs
3 where grantee = '&USERNAME';


What is Privilege on Columns of table.

SQL> select TABLE_NAME,COLUMN_NAME,PRIVILEGE
2 from dba_col_privs
3 where grantee = '&USERNAME';

No comments: