Просмотр исходного текста страницы Oracle PL/SQL/System Tables Views/ROLE TAB PRIVS

==Determine what object privileges were available through roles granted him==



   
  <!-- start source code -->
   
    <source lang="sql">

--Determine what object privileges were available through roles granted him
--connect sqle/password;
SELECT ROLE, OWNER, TABLE_NAME, PRIVILEGE FROM ROLE_TAB_PRIVS;

           
       </source>
    
   


==Privileges available to the current user==



   
  <!-- start source code -->
   
    <source lang="sql">

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>
           
       </source>