http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2FROLE_TAB_PRIVS 2026-04-03T23:14:47Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/ROLE_TAB_PRIVS&diff=2302&oldid=prev 2010-05-26T13:45:19Z

<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/System_Tables_Views/ROLE_TAB_PRIVS&diff=2303&oldid=prev 2010-05-26T10:01:20Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==Determine what object privileges were available through roles granted him==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> --Determine what object privileges were available through roles granted him<br /> --connect sqle/password;<br /> SELECT ROLE, OWNER, TABLE_NAME, PRIVILEGE FROM ROLE_TAB_PRIVS;<br /> <br /> <br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==Privileges available to the current user==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> SQL&gt; -- Privileges available to the current user.<br /> SQL&gt;<br /> SQL&gt; desc ROLE_TAB_PRIVS;<br /> Name Null? Type<br /> ----------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------<br /> ROLE NOT NULL VARCHAR2(30)<br /> OWNER NOT NULL VARCHAR2(30)<br /> TABLE_NAME NOT NULL VARCHAR2(30)<br /> COLUMN_NAME VARCHAR2(30)<br /> PRIVILEGE NOT NULL VARCHAR2(40)<br /> GRANTABLE VARCHAR2(3)<br /> SQL&gt;<br /> SQL&gt; select * from ROLE_TAB_PRIVS where rownum &lt; 200;<br /> ROLE OWNER TABLE_NAME COLUMN_NAME PRIVILEGE GRA<br /> ------------------------------ ------------------------------ -------------------- ------------------------------ -------------------- ---<br /> DBA SYS AW$ DEBUG NO<br /> DBA SYS AW$ SELECT NO<br /> DBA SYS PS$ DEBUG NO<br /> DBA SYS PS$ SELECT NO<br /> DBA SYS AWSEQ$ ALTER NO<br /> DBA SYS AWSEQ$ SELECT NO<br /> DBA SYS AW_OBJ$ DEBUG NO<br /> DBA SYS AW_OBJ$ SELECT NO<br /> DBA SYS AW_PROP$ DEBUG NO<br /> DBA SYS AW_PROP$ SELECT NO<br /> DBA SYS DBMS_TDB EXECUTE NO<br /> DBA SYS OUTLN_PKG EXECUTE NO<br /> DBA SYS MAP_OBJECT ALTER NO<br /> DBA SYS MAP_OBJECT DEBUG NO<br /> DBA SYS MAP_OBJECT DELETE NO<br /> DBA SYS MAP_OBJECT INSERT NO<br /> DBA SYS MAP_OBJECT SELECT NO<br /> DBA SYS MAP_OBJECT UPDATE NO<br /> DBA SYS MAP_OBJECT FLASHBACK NO<br /> DBA SYS MAP_OBJECT QUERY REWRITE NO<br /> DBA SYS MAP_OBJECT ON COMMIT REFRESH NO<br /> DBA SYS DBMS_MONITOR EXECUTE NO<br /> DBA SYS DBMS_SERVICE EXECUTE NO<br /> DBA SYS DBMS_LOGSTDBY EXECUTE NO<br /> DBA SYS DBMS_UADV_ARR EXECUTE NO<br /> DBA SYS DBMS_UNDO_ADV EXECUTE NO<br /> DBA SYS DBMS_DEFER_SYS EXECUTE NO<br /> DBA SYS DBMS_FLASHBACK EXECUTE NO<br /> DBA SYS DBMS_RESUMABLE EXECUTE NO<br /> DBA SYS LOAD_UNDO_STAT EXECUTE NO<br /> DBA SYS OUTLN_EDIT_PKG EXECUTE NO<br /> DBA SYS RESET_UNDO_STAT EXECUTE NO<br /> DBA SYS DBMS_DEFER_QUERY EXECUTE NO<br /> DBA SYS DBMS_STORAGE_MAP EXECUTE NO<br /> DBA SYS DBMS_SERVER_ALERT EXECUTE NO<br /> DBA SYS DBMS_SERVER_TRACE EXECUTE NO<br /> DBA SYS DBMS_WORKLOAD_REPOSI EXECUTE NO<br /> TORY<br /> DBA SYS DBMS_FEATURE_USAGE_R EXECUTE NO<br /> EPORT<br /> XDBADMIN SYS DBA_EPG_DAD_AUTHORIZ SELECT NO<br /> ATION<br /> XDBADMIN XDB XDB$CONFIG ALTER NO<br /> XDBADMIN XDB XDB$CONFIG DEBUG NO<br /> XDBADMIN XDB XDB$CONFIG DELETE NO<br /> XDBADMIN XDB XDB$CONFIG INSERT NO<br /> XDBADMIN XDB XDB$CONFIG SELECT NO<br /> XDBADMIN XDB XDB$CONFIG UPDATE NO<br /> XDBADMIN XDB XDB$CONFIG FLASHBACK NO<br /> XDBADMIN XDB XDB$CONFIG QUERY REWRITE NO<br /> XDBADMIN XDB XDB$CONFIG ON COMMIT REFRESH NO<br /> PLUSTRACE SYS V_$MYSTAT SELECT NO<br /> PLUSTRACE SYS V_$SESSTAT SELECT NO<br /> PLUSTRACE SYS V_$STATNAME SELECT NO<br /> HS_ADMIN_ROLE SYS DBMS_HS EXECUTE NO<br /> HS_ADMIN_ROLE SYS HS_ALL_DD SELECT NO<br /> HS_ADMIN_ROLE SYS HS_BASE_DD SELECT NO<br /> HS_ADMIN_ROLE SYS HS_INST_DD SELECT NO<br /> HS_ADMIN_ROLE SYS HS_ALL_CAPS SELECT NO<br /> HS_ADMIN_ROLE SYS HS_CLASS_DD SELECT NO<br /> HS_ADMIN_ROLE SYS HS_FDS_INST SELECT NO<br /> HS_ADMIN_ROLE SYS HS_ALL_INITS SELECT NO<br /> HS_ADMIN_ROLE SYS HS_BASE_CAPS SELECT NO<br /> HS_ADMIN_ROLE SYS HS_FDS_CLASS SELECT NO<br /> HS_ADMIN_ROLE SYS HS_INST_CAPS SELECT NO<br /> HS_ADMIN_ROLE SYS HS_INST_INIT SELECT NO<br /> HS_ADMIN_ROLE SYS HS_CLASS_CAPS SELECT NO<br /> HS_ADMIN_ROLE SYS HS_CLASS_INIT SELECT NO<br /> HS_ADMIN_ROLE SYS HS_FDS_CLASS_DATE SELECT NO<br /> EXP_FULL_DATABASE SYS INCEXP DELETE NO<br /> EXP_FULL_DATABASE SYS INCEXP INSERT NO<br /> EXP_FULL_DATABASE SYS INCEXP UPDATE NO<br /> EXP_FULL_DATABASE SYS INCFIL DELETE NO<br /> EXP_FULL_DATABASE SYS INCFIL INSERT NO<br /> EXP_FULL_DATABASE SYS INCFIL UPDATE NO<br /> EXP_FULL_DATABASE SYS INCVID DELETE NO<br /> EXP_FULL_DATABASE SYS INCVID INSERT NO<br /> EXP_FULL_DATABASE SYS INCVID UPDATE NO<br /> EXP_FULL_DATABASE SYS EXU8LNK SELECT NO<br /> EXP_FULL_DATABASE SYS EXU9LNK SELECT NO<br /> EXP_FULL_DATABASE SYS EXU10LNK SELECT NO<br /> EXP_FULL_DATABASE SYS DBMS_IJOB EXECUTE NO<br /> EXP_FULL_DATABASE SYS _DBA_APPLY SELECT NO<br /> EXP_FULL_DATABASE SYS _DBA_CAPTURE SELECT NO<br /> EXP_FULL_DATABASE SYS DATA_PUMP_DIR READ NO<br /> EXP_FULL_DATABASE SYS DATA_PUMP_DIR WRITE NO<br /> EXP_FULL_DATABASE SYS DBMS_IREFRESH EXECUTE NO<br /> EXP_FULL_DATABASE SYS DBMS_RULE_EXIMP EXECUTE NO<br /> EXP_FULL_DATABASE SYS _DBA_APPLY_ERROR SELECT NO<br /> EXP_FULL_DATABASE SYS DBMS_PSWMG_IMPORT EXECUTE NO<br /> EXP_FULL_DATABASE SYS _DBA_STREAMS_RULES SELECT NO<br /> EXP_FULL_DATABASE SYS DBMSZEXP_SYSPKGGRNT EXECUTE NO<br /> EXP_FULL_DATABASE SYS _DBA_APPLY_PROGRESS SELECT NO<br /> EXP_FULL_DATABASE SYS DBMS_TRANSFORM_EXIMP EXECUTE NO<br /> ROLE OWNER TABLE_NAME COLUMN_NAME PRIVILEGE GRA<br /> ------------------------------ ------------------------------ -------------------- ------------------------------ -------------------- ---<br /> EXP_FULL_DATABASE SYS _DBA_APPLY_ERROR_TXN SELECT NO<br /> EXP_FULL_DATABASE SYS _DBA_APPLY_MILESTONE SELECT NO<br /> EXP_FULL_DATABASE SYS _DBA_APPLY_SPILL_TXN SELECT NO<br /> EXP_FULL_DATABASE SYS DBMS_IAS_INST_UTL_EX EXECUTE NO<br /> P<br /> EXP_FULL_DATABASE SYS _DBA_APPLY_SOURCE_OB SELECT NO<br /> J<br /> EXP_FULL_DATABASE SYS DBMS_AQ_IMPORT_INTER EXECUTE NO<br /> NAL<br /> EXP_FULL_DATABASE SYS _DBA_APPLY_ERROR_HAN SELECT NO<br /> DLER<br /> EXP_FULL_DATABASE SYS _DBA_APPLY_SOURCE_SC SELECT NO<br /> HEMA<br /> EXP_FULL_DATABASE SYS _DBA_STREAMS_MESSAGE SELECT NO<br /> _RULES<br /> EXP_FULL_DATABASE SYS _DBA_APPLY_CONF_HDLR SELECT NO<br /> _COLUMNS<br /> EXP_FULL_DATABASE SYS _DBA_STREAMS_PRIVILE SELECT NO<br /> GED_USER<br /> EXP_FULL_DATABASE SYS _DBA_STREAMS_TRANSFO SELECT NO<br /> RMATIONS<br /> EXP_FULL_DATABASE SYS _DBA_STREAMS_MESSAGE SELECT NO<br /> _CONSUMERS<br /> EXP_FULL_DATABASE SYS _DBA_STREAMS_MSG_NOT SELECT NO<br /> IFICATIONS<br /> IMP_FULL_DATABASE SYS DBMS_IJOB EXECUTE NO<br /> IMP_FULL_DATABASE SYS DBMS_AQADM EXECUTE NO<br /> IMP_FULL_DATABASE SYS DATA_PUMP_DIR READ NO<br /> IMP_FULL_DATABASE SYS DATA_PUMP_DIR WRITE NO<br /> IMP_FULL_DATABASE SYS DBMS_IREFRESH EXECUTE NO<br /> IMP_FULL_DATABASE SYS EXPIMP_TTS_CT$ DELETE NO<br /> IMP_FULL_DATABASE SYS EXPIMP_TTS_CT$ INSERT NO<br /> IMP_FULL_DATABASE SYS EXPIMP_TTS_CT$ SELECT NO<br /> IMP_FULL_DATABASE SYS EXPIMP_TTS_CT$ UPDATE NO<br /> IMP_FULL_DATABASE SYS DBMS_REPCAT_MIG EXECUTE NO<br /> IMP_FULL_DATABASE SYS DBMS_RULE_EXIMP EXECUTE NO<br /> IMP_FULL_DATABASE SYS DBMS_PSWMG_IMPORT EXECUTE NO<br /> IMP_FULL_DATABASE SYS DBMS_TRANSFORM_EXIMP EXECUTE NO<br /> IMP_FULL_DATABASE SYS DBMS_AQ_IMPORT_INTER EXECUTE NO<br /> NAL<br /> DELETE_CATALOG_ROLE SYS AUD$ DELETE NO<br /> DELETE_CATALOG_ROLE SYS FGA_LOG$ DELETE NO<br /> SELECT_CATALOG_ROLE SYS TP$ SELECT NO<br /> SELECT_CATALOG_ROLE SYS PS1$ SELECT NO<br /> SELECT_CATALOG_ROLE SYS TSP$ SELECT NO<br /> SELECT_CATALOG_ROLE SYS PSS1$ SELECT NO<br /> SELECT_CATALOG_ROLE SYS V_$AQ SELECT NO<br /> SELECT_CATALOG_ROLE SYS DEFLOB SELECT NO<br /> SELECT_CATALOG_ROLE SYS GV_$AQ SELECT NO<br /> SELECT_CATALOG_ROLE SYS V_$AQ1 SELECT NO<br /> SELECT_CATALOG_ROLE SYS V_$BSP SELECT NO<br /> SELECT_CATALOG_ROLE SYS V_$LOG SELECT NO<br /> SELECT_CATALOG_ROLE SYS V_$SGA SELECT NO<br /> SELECT_CATALOG_ROLE SYS V_$SQL SELECT NO<br /> SELECT_CATALOG_ROLE SYS DBA_AWS SELECT NO<br /> SELECT_CATALOG_ROLE SYS DEFCALL SELECT NO<br /> SELECT_CATALOG_ROLE SYS DEFTRAN SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8ASC SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8AUD SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8CCL SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8CCO SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8CGR SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8CLU SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8CMT SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8COE SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8COL SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8CON SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8COO SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8CSN SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8DEL SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8DFR SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8DIR SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8ERC SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8FIL SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8FPT SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8GRN SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8GRS SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8HST SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8IND SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8INK SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8IOV SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8IXP SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8JBQ SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8LIB SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8LOB SELECT NO<br /> ROLE OWNER TABLE_NAME COLUMN_NAME PRIVILEGE GRA<br /> ------------------------------ ------------------------------ -------------------- ------------------------------ -------------------- ---<br /> SELECT_CATALOG_ROLE SYS EXU8NTB SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8NXP SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8OID SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8PDS SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8PHS SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8PNT SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8POK SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8PRF SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8PRR SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8PST SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8PVF SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8REF SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8RFS SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8RGC SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8RGS SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8RIF SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8RLG SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8ROL SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8RSG SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8SCM SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8SEQ SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8SPR SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8SPS SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8SPV SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8SRT SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8STO SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8SYN SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8TAB SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8TBP SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8TBS SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8TGR SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8TSL SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8TSN SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8TSQ SELECT NO<br /> SELECT_CATALOG_ROLE SYS EXU8TYP SELECT NO<br /> 199 rows selected.<br /> SQL&gt;<br /> <br /> &lt;/source&gt;</div>

Admin