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:
Post a Comment