set pages 10000 line 200col owner format a20col table_name format a30col privilege format a30select owner, table_name, privilegefrom dba_tab_privswhere grantee = '&USER'union allselect null, null, privilegefrom dba_sys_privswhere grantee = '&USER'union allselect null, null, granted_rolefrom dba_role_privswhere grantee = '&USER';
No comments:
Post a Comment