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