http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2Fdba_tab_privs Oracle PL/SQL Tutorial/System Tables Data Dictionary/dba tab privs - История изменений 2026-05-25T21:20:52Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/dba_tab_privs&diff=3873&oldid=prev в 13:45, 26 мая 2010 2010-05-26T13:45:46Z <p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table> http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/dba_tab_privs&diff=3874&oldid=prev Admin: 1 версия 2010-05-26T10:08:03Z <p>1 версия</p> <p><b>Новая страница</b></p><div>== Find out all dba table privileges==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt; COLUMN object FORMAT a25<br /> SQL&gt; COLUMN grantee FORMAT a15<br /> SQL&gt; SELECT owner || &quot;.&quot; || table_name object,<br /> 2 privilege what_granted, grantable, grantee<br /> 3 FROM dba_tab_privs<br /> 4 WHERE NOT EXISTS<br /> 5 (SELECT &quot;x&quot;<br /> 6 FROM dba_users<br /> 7 WHERE username = grantee)<br /> 8 and rownum &lt; 50<br /> 9 AND privilege = &quot;EXECUTE&quot;<br /> 10 ORDER BY 1,2,3;<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> SYS.ANYDATA EXECUTE YES<br /> PUBLIC<br /> SYS.ANYDATASET EXECUTE YES<br /> PUBLIC<br /> SYS.ANYTYPE EXECUTE YES<br /> PUBLIC<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> SYS.CREATE_TABLE_COST_COL EXECUTE NO<br /> INFO<br /> PUBLIC<br /> SYS.CREATE_TABLE_COST_COL EXECUTE NO<br /> UMNS<br /> PUBLIC<br /> SYS.DBMSOUTPUT_LINESARRAY EXECUTE NO<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> PUBLIC<br /> SYS.DBMS_ADVISOR EXECUTE NO<br /> PUBLIC<br /> SYS.DBMS_ALERT EXECUTE NO<br /> EXECUTE_CATALOG<br /> _ROLE<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> SYS.DBMS_APPLICATION_INFO EXECUTE NO<br /> PUBLIC<br /> SYS.DBMS_ASSERT EXECUTE NO<br /> PUBLIC<br /> SYS.DBMS_DESCRIBE EXECUTE NO<br /> PUBLIC<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> SYS.DBMS_ERRLOG EXECUTE NO<br /> PUBLIC<br /> SYS.DBMS_EXPORT_EXTENSION EXECUTE NO<br /> PUBLIC<br /> SYS.DBMS_JAVA_TEST EXECUTE NO<br /> PUBLIC<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> SYS.DBMS_JOB EXECUTE YES<br /> PUBLIC<br /> SYS.DBMS_LOB EXECUTE NO<br /> PUBLIC<br /> SYS.DBMS_LOCK EXECUTE NO<br /> EXECUTE_CATALOG<br /> _ROLE<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> SYS.DBMS_OUTPUT EXECUTE NO<br /> PUBLIC<br /> SYS.DBMS_PCLXUTIL EXECUTE NO<br /> PUBLIC<br /> SYS.DBMS_PICKLER EXECUTE NO<br /> PUBLIC<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> SYS.DBMS_PIPE EXECUTE NO<br /> EXECUTE_CATALOG<br /> _ROLE<br /> SYS.DBMS_ROWID EXECUTE NO<br /> PUBLIC<br /> SYS.DBMS_SESSION EXECUTE NO<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> PUBLIC<br /> SYS.DBMS_SPACE EXECUTE NO<br /> PUBLIC<br /> SYS.DBMS_SQL EXECUTE NO<br /> PUBLIC<br /> SYS.DBMS_STANDARD EXECUTE NO<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> PUBLIC<br /> SYS.DBMS_TRANSACTION EXECUTE NO<br /> PUBLIC<br /> SYS.DBMS_TYPES EXECUTE NO<br /> PUBLIC<br /> SYS.DBMS_UTILITY EXECUTE NO<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> PUBLIC<br /> SYS.DBMS_WARNING EXECUTE YES<br /> PUBLIC<br /> SYS.DIANA EXECUTE NO<br /> EXECUTE_CATALOG<br /> _ROLE<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> SYS.DIUTIL EXECUTE NO<br /> PUBLIC<br /> SYS.GETTVOID EXECUTE NO<br /> PUBLIC<br /> SYS.ODCICOLINFO EXECUTE YES<br /> PUBLIC<br /> <br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> SYS.PIDL EXECUTE NO<br /> EXECUTE_CATALOG<br /> _ROLE<br /> SYS.PLITBLM EXECUTE NO<br /> PUBLIC<br /> SYS.PSTUB EXECUTE NO<br /> PUBLIC<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> SYS.PSTUBT EXECUTE NO<br /> PUBLIC<br /> SYS.RE$NV_LIST EXECUTE NO<br /> PUBLIC<br /> SYS.STANDARD EXECUTE NO<br /> PUBLIC<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> SYS.SUBPTXT EXECUTE NO<br /> PUBLIC<br /> SYS.UTL_COMPRESS EXECUTE NO<br /> PUBLIC<br /> SYS.UTL_ENCODE EXECUTE NO<br /> PUBLIC<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> SYS.UTL_GDK EXECUTE NO<br /> PUBLIC<br /> SYS.UTL_I18N EXECUTE NO<br /> PUBLIC<br /> SYS.UTL_INADDR EXECUTE NO<br /> PUBLIC<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> SYS.UTL_LMS EXECUTE NO<br /> PUBLIC<br /> SYS.UTL_RAW EXECUTE NO<br /> PUBLIC<br /> SYS.UTL_URL EXECUTE NO<br /> PUBLIC<br /> OBJECT WHAT_GRANTED GRA<br /> ------------------------- ---------------------------------------- ---<br /> GRANTEE<br /> ---------------<br /> <br /> 49 rows selected.<br /> SQL&gt;<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == Object Grants to Roles==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; SELECT owner || &quot;.&quot; || table_name obj,<br /> 2 privilege what_granted, grantable, grantee<br /> 3 FROM sys.dba_tab_privs<br /> 4 WHERE NOT EXISTS<br /> 5 (SELECT &quot;x&quot;<br /> 6 FROM sys.dba_users<br /> 7 WHERE username = grantee)<br /> 8 and rownum &lt; 50<br /> 9 ORDER BY 1,2,3;<br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> OUTLN.OL$<br /> SELECT NO SELECT_CATALOG_ROLE<br /> OUTLN.OL$HINTS<br /> SELECT NO SELECT_CATALOG_ROLE<br /> OUTLN.OL$NODES<br /> SELECT NO SELECT_CATALOG_ROLE<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.AUD$<br /> DELETE NO DELETE_CATALOG_ROLE<br /> SYS.AUX_STATS$<br /> DELETE NO GATHER_SYSTEM_STATISTICS<br /> SYS.AUX_STATS$<br /> INSERT NO GATHER_SYSTEM_STATISTICS<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.AUX_STATS$<br /> SELECT NO GATHER_SYSTEM_STATISTICS<br /> SYS.AUX_STATS$<br /> UPDATE NO GATHER_SYSTEM_STATISTICS<br /> SYS.AW$<br /> DEBUG NO DBA<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.AW$<br /> SELECT NO DBA<br /> SYS.AWSEQ$<br /> ALTER NO DBA<br /> SYS.AWSEQ$<br /> SELECT NO DBA<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.AW_OBJ$<br /> DEBUG NO DBA<br /> SYS.AW_OBJ$<br /> SELECT NO DBA<br /> SYS.AW_PROP$<br /> DEBUG NO DBA<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.AW_PROP$<br /> SELECT NO DBA<br /> SYS.DBMS_STANDARD<br /> EXECUTE NO PUBLIC<br /> SYS.DUAL<br /> SELECT YES PUBLIC<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.EXPIMP_TTS_CT$<br /> DELETE NO IMP_FULL_DATABASE<br /> SYS.EXPIMP_TTS_CT$<br /> INSERT NO IMP_FULL_DATABASE<br /> SYS.EXPIMP_TTS_CT$<br /> SELECT NO IMP_FULL_DATABASE<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.EXPIMP_TTS_CT$<br /> UPDATE NO IMP_FULL_DATABASE<br /> SYS.FGA_LOG$<br /> DELETE NO DELETE_CATALOG_ROLE<br /> SYS.INCEXP<br /> DELETE NO EXP_FULL_DATABASE<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.INCEXP<br /> INSERT NO EXP_FULL_DATABASE<br /> SYS.INCEXP<br /> UPDATE NO EXP_FULL_DATABASE<br /> SYS.INCFIL<br /> DELETE NO EXP_FULL_DATABASE<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.INCFIL<br /> INSERT NO EXP_FULL_DATABASE<br /> SYS.INCFIL<br /> UPDATE NO EXP_FULL_DATABASE<br /> SYS.INCVID<br /> DELETE NO EXP_FULL_DATABASE<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.INCVID<br /> INSERT NO EXP_FULL_DATABASE<br /> SYS.INCVID<br /> UPDATE NO EXP_FULL_DATABASE<br /> SYS.MAP_OBJECT<br /> ALTER NO DBA<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.MAP_OBJECT<br /> DEBUG NO DBA<br /> SYS.MAP_OBJECT<br /> DELETE NO DBA<br /> SYS.MAP_OBJECT<br /> FLASHBACK NO DBA<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.MAP_OBJECT<br /> INSERT NO DBA<br /> SYS.MAP_OBJECT<br /> ON COMMIT REFRESH NO DBA<br /> SYS.MAP_OBJECT<br /> QUERY REWRITE NO DBA<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.MAP_OBJECT<br /> SELECT NO DBA<br /> SYS.MAP_OBJECT<br /> SELECT NO SELECT_CATALOG_ROLE<br /> SYS.MAP_OBJECT<br /> UPDATE NO DBA<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.PS$<br /> DEBUG NO DBA<br /> SYS.PS$<br /> SELECT NO DBA<br /> SYS.RE$NV_LIST<br /> EXECUTE NO PUBLIC<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.STANDARD<br /> EXECUTE NO PUBLIC<br /> SYS.STMT_AUDIT_OPTION_MAP<br /> SELECT NO PUBLIC<br /> SYS.SYSTEM_PRIVILEGE_MAP<br /> SELECT YES PUBLIC<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA GRANTEE<br /> ---------------------------------------- --- ------------------------------<br /> SYS.TABLE_PRIVILEGE_MAP<br /> SELECT YES PUBLIC<br /> <br /> 49 rows selected.<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == Object Grants to Users==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; SELECT b.owner || &quot;.&quot; || b.table_name obj,<br /> 2 b.privilege what_granted, b.grantable,<br /> 3 a.username<br /> 4 FROM sys.dba_users a, sys.dba_tab_privs b<br /> 5 WHERE a.username = b.grantee<br /> 6 and rownum &lt; 50<br /> 7 ORDER BY 1,2,3;<br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.ARGUMENT$<br /> SELECT YES CTXSYS<br /> SYS.CCOL$<br /> SELECT YES CTXSYS<br /> SYS.CDEF$<br /> SELECT YES CTXSYS<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.COL$<br /> SELECT YES CTXSYS<br /> SYS.CON$<br /> SELECT YES CTXSYS<br /> SYS.ICOL$<br /> SELECT YES CTXSYS<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.INCEXP<br /> ALTER NO SYSTEM<br /> SYS.INCEXP<br /> DEBUG NO SYSTEM<br /> SYS.INCEXP<br /> DELETE NO SYSTEM<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.INCEXP<br /> FLASHBACK NO SYSTEM<br /> SYS.INCEXP<br /> INDEX NO SYSTEM<br /> SYS.INCEXP<br /> INSERT NO SYSTEM<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.INCEXP<br /> ON COMMIT REFRESH NO SYSTEM<br /> SYS.INCEXP<br /> QUERY REWRITE NO SYSTEM<br /> SYS.INCEXP<br /> REFERENCES NO SYSTEM<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.INCEXP<br /> SELECT NO SYSTEM<br /> SYS.INCEXP<br /> UPDATE NO SYSTEM<br /> SYS.INCFIL<br /> DEBUG NO SYSTEM<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.INCFIL<br /> DELETE NO SYSTEM<br /> SYS.INCFIL<br /> FLASHBACK NO SYSTEM<br /> SYS.INCFIL<br /> INDEX NO SYSTEM<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.INCFIL<br /> INSERT NO SYSTEM<br /> SYS.INCFIL<br /> ON COMMIT REFRESH NO SYSTEM<br /> SYS.INCFIL<br /> QUERY REWRITE NO SYSTEM<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.INCFIL<br /> REFERENCES NO SYSTEM<br /> SYS.INCFIL<br /> SELECT NO SYSTEM<br /> SYS.INCFIL<br /> UPDATE NO SYSTEM<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.INCVID<br /> ALTER NO SYSTEM<br /> SYS.INCVID<br /> DEBUG NO SYSTEM<br /> SYS.INCVID<br /> DELETE NO SYSTEM<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.INCVID<br /> FLASHBACK NO SYSTEM<br /> SYS.INCVID<br /> INDEX NO SYSTEM<br /> SYS.INCVID<br /> INSERT NO SYSTEM<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.INCVID<br /> ON COMMIT REFRESH NO SYSTEM<br /> SYS.INCVID<br /> QUERY REWRITE NO SYSTEM<br /> SYS.INCVID<br /> REFERENCES NO SYSTEM<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.INCVID<br /> SELECT NO SYSTEM<br /> SYS.INCVID<br /> UPDATE NO SYSTEM<br /> SYS.IND$<br /> SELECT YES CTXSYS<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.OBJ$<br /> SELECT NO FLOWS_020100<br /> SYS.OBJ$<br /> SELECT YES CTXSYS<br /> SYS.SYN$<br /> SELECT YES CTXSYS<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.SYSAUTH$<br /> SELECT YES CTXSYS<br /> SYS.TAB$<br /> SELECT YES CTXSYS<br /> SYS.TS$<br /> SELECT YES CTXSYS<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.USER$<br /> SELECT NO XDB<br /> SYS.USER$<br /> SELECT YES CTXSYS<br /> SYS.USER$<br /> SELECT YES FLOWS_020100<br /> <br /> OBJ<br /> -------------------------------------------------------------<br /> WHAT_GRANTED GRA USERNAME<br /> ---------------------------------------- --- ------------------------------<br /> SYS.VIEW$<br /> SELECT YES CTXSYS<br /> <br /> 49 rows selected.<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == User Table Privileges report==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; SET FEEDBACK OFF<br /> SQL&gt; SET PAGESIZE 20<br /> SQL&gt; SET LINESIZE 77<br /> SQL&gt; SET HEADING ON<br /> SQL&gt;<br /> SQL&gt; COLUMN username FORMAT A12 HEADING &quot;User&quot;<br /> SQL&gt; COLUMN privilege FORMAT A20 HEADING &quot;Privilege&quot;<br /> SQL&gt; COLUMN owner FORMAT A12 HEADING &quot;Table Owner&quot;<br /> SQL&gt; COLUMN table_name FORMAT A30 HEADING &quot;Table Name&quot;<br /> SQL&gt; TTITLE LEFT &quot;User Table Privileges&quot; RIGHT &quot;Page &quot; FORMAT 999 SQL.PNO SKIP 2<br /> SQL&gt;<br /> SQL&gt; SELECT username, privilege, owner, table_name<br /> 2 FROM dba_users, dba_tab_privs<br /> 3 WHERE username = grantee<br /> 4 ORDER BY username, owner, table_name, privilege;<br /> User Table Privileges Page 1<br /> User Privilege Table Owner Table Name<br /> ------------ -------------------- ------------ ------------------------------<br /> ANONYMOUS EXECUTE FLOWS_020100 WWV_FLOW_EPG_INCLUDE_MODULES<br /> ANONYMOUS ALTER FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS DEBUG FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS DELETE FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS FLASHBACK FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS INDEX FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS INSERT FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS ON COMMIT REFRESH FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS QUERY REWRITE FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS REFERENCES FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS SELECT FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> ANONYMOUS UPDATE FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> CTXSYS SELECT SYS ARGUMENT$<br /> CTXSYS SELECT SYS CCOL$<br /> CTXSYS SELECT SYS CDEF$<br /> User Table Privileges Page 2<br /> User Privilege Table Owner Table Name<br /> ------------ -------------------- ------------ ------------------------------<br /> CTXSYS SELECT SYS COL$<br /> CTXSYS SELECT SYS COLTYPE$<br /> CTXSYS SELECT SYS CON$<br /> CTXSYS SELECT SYS DBA_COLL_TYPES<br /> CTXSYS SELECT SYS DBA_CONSTRAINTS<br /> CTXSYS SELECT SYS DBA_CONS_COLUMNS<br /> CTXSYS SELECT SYS DBA_DB_LINKS<br /> CTXSYS SELECT SYS DBA_INDEXTYPES<br /> CTXSYS SELECT SYS DBA_JOBS<br /> CTXSYS SELECT SYS DBA_JOBS_RUNNING<br /> CTXSYS SELECT SYS DBA_OBJECTS<br /> CTXSYS SELECT SYS DBA_ROLES<br /> CTXSYS SELECT SYS DBA_ROLE_PRIVS<br /> CTXSYS SELECT SYS DBA_SYNONYMS<br /> CTXSYS SELECT SYS DBA_SYS_PRIVS<br /> User Table Privileges Page 3<br /> User Privilege Table Owner Table Name<br /> ------------ -------------------- ------------ ------------------------------<br /> CTXSYS SELECT SYS DBA_TABLES<br /> CTXSYS SELECT SYS DBA_TAB_COLS<br /> CTXSYS SELECT SYS DBA_TAB_COLUMNS<br /> CTXSYS SELECT SYS DBA_TAB_PARTITIONS<br /> CTXSYS SELECT SYS DBA_TAB_PRIVS<br /> CTXSYS SELECT SYS DBA_TYPES<br /> CTXSYS SELECT SYS DBA_TYPE_ATTRS<br /> CTXSYS SELECT SYS DBA_USERS<br /> CTXSYS EXECUTE SYS DBMS_LOCK<br /> CTXSYS EXECUTE SYS DBMS_PIPE<br /> CTXSYS EXECUTE SYS DBMS_REGISTRY<br /> CTXSYS SELECT SYS GV_$PARAMETER<br /> CTXSYS SELECT SYS HIST_HEAD$<br /> CTXSYS SELECT SYS ICOL$<br /> CTXSYS SELECT SYS IND$<br /> User Table Privileges Page 4<br /> User Privilege Table Owner Table Name<br /> ------------ -------------------- ------------ ------------------------------<br /> CTXSYS SELECT SYS INDPART$<br /> CTXSYS SELECT SYS LOB$<br /> CTXSYS SELECT SYS LOBFRAG$<br /> CTXSYS SELECT SYS OBJ$<br /> CTXSYS SELECT SYS PARTOBJ$<br /> CTXSYS SELECT SYS SYN$<br /> CTXSYS SELECT SYS SYSAUTH$<br /> CTXSYS SELECT SYS TAB$<br /> CTXSYS SELECT SYS TABPART$<br /> CTXSYS SELECT SYS TS$<br /> CTXSYS SELECT SYS USER$<br /> CTXSYS EXECUTE SYS VALIDATE_CONTEXT<br /> CTXSYS SELECT SYS VIEW$<br /> CTXSYS SELECT SYS V_$PARAMETER<br /> CTXSYS SELECT SYS V_$RESOURCE<br /> User Table Privileges Page 5<br /> User Privilege Table Owner Table Name<br /> ------------ -------------------- ------------ ------------------------------<br /> CTXSYS SELECT SYS V_$SESSION<br /> CTXSYS SELECT SYS V_$THREAD<br /> DBSNMP EXECUTE SYS DBMS_SERVER_ALERT<br /> FLOWS_020100 EXECUTE CTXSYS CTX_DDL<br /> FLOWS_020100 EXECUTE CTXSYS CTX_DOC<br /> FLOWS_020100 ALTER FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 DEBUG FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 DELETE FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 FLASHBACK FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 INDEX FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 INSERT FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 ON COMMIT REFRESH FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 QUERY REWRITE FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 REFERENCES FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 SELECT FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> User Table Privileges Page 6<br /> User Privilege Table Owner Table Name<br /> ------------ -------------------- ------------ ------------------------------<br /> FLOWS_020100 UPDATE FLOWS_FILES WWV_FLOW_FILE_OBJECTS$<br /> FLOWS_020100 SELECT SYS DBA_DATA_FILES<br /> FLOWS_020100 SELECT SYS DBA_FREE_SPACE<br /> FLOWS_020100 SELECT SYS DBA_IND_COLUMNS<br /> FLOWS_020100 SELECT SYS DBA_OBJECTS<br /> FLOWS_020100 SELECT SYS DBA_ROLE_PRIVS<br /> FLOWS_020100 SELECT SYS DBA_ROLLBACK_SEGS<br /> FLOWS_020100 SELECT SYS DBA_SEGMENTS<br /> FLOWS_020100 SELECT SYS DBA_SEQUENCES<br /> FLOWS_020100 SELECT SYS DBA_SYS_PRIVS<br /> FLOWS_020100 SELECT SYS DBA_TABLES<br /> FLOWS_020100 SELECT SYS DBA_TABLESPACES<br /> FLOWS_020100 SELECT SYS DBA_TAB_COLUMNS<br /> FLOWS_020100 SELECT SYS DBA_TAB_PRIVS<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; SET FEEDBACK ON<br /> SQL&gt;&lt;/source&gt;</div> Admin