Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Object Grants to Roles

SQL> SQL> SELECT owner || '.' || table_name obj,   2         privilege what_granted, grantable, grantee   3  FROM   sys.dba_tab_privs   4  WHERE  NOT EXISTS   5  (SELECT  'x'   6  FROM     sys.dba_users   7  WHERE    username = grantee)   8  and    rownum < 50   9  ORDER BY 1,2,3; OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ OUTLN.OL$ SELECT                                   NO  SELECT_CATALOG_ROLE OUTLN.OL$HINTS SELECT                                   NO  SELECT_CATALOG_ROLE OUTLN.OL$NODES SELECT                                   NO  SELECT_CATALOG_ROLE OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ SYS.AUD$ DELETE                                   NO  DELETE_CATALOG_ROLE SYS.AUX_STATS$ DELETE                                   NO  GATHER_SYSTEM_STATISTICS SYS.AUX_STATS$ INSERT                                   NO  GATHER_SYSTEM_STATISTICS OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ SYS.AUX_STATS$ SELECT                                   NO  GATHER_SYSTEM_STATISTICS SYS.AUX_STATS$ UPDATE                                   NO  GATHER_SYSTEM_STATISTICS SYS.AW$ DEBUG                                    NO  DBA OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ SYS.AW$ SELECT                                   NO  DBA SYS.AWSEQ$ ALTER                                    NO  DBA SYS.AWSEQ$ SELECT                                   NO  DBA OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ SYS.AW_OBJ$ DEBUG                                    NO  DBA SYS.AW_OBJ$ SELECT                                   NO  DBA SYS.AW_PROP$ DEBUG                                    NO  DBA OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ SYS.AW_PROP$ SELECT                                   NO  DBA SYS.DBMS_STANDARD EXECUTE                                  NO  PUBLIC SYS.DUAL SELECT                                   YES PUBLIC OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ 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 OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ SYS.EXPIMP_TTS_CT$ UPDATE                                   NO  IMP_FULL_DATABASE SYS.FGA_LOG$ DELETE                                   NO  DELETE_CATALOG_ROLE SYS.INCEXP DELETE                                   NO  EXP_FULL_DATABASE OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ SYS.INCEXP INSERT                                   NO  EXP_FULL_DATABASE SYS.INCEXP UPDATE                                   NO  EXP_FULL_DATABASE SYS.INCFIL DELETE                                   NO  EXP_FULL_DATABASE OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ SYS.INCFIL INSERT                                   NO  EXP_FULL_DATABASE SYS.INCFIL UPDATE                                   NO  EXP_FULL_DATABASE SYS.INCVID DELETE                                   NO  EXP_FULL_DATABASE OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ SYS.INCVID INSERT                                   NO  EXP_FULL_DATABASE SYS.INCVID UPDATE                                   NO  EXP_FULL_DATABASE SYS.MAP_OBJECT ALTER                                    NO  DBA OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ SYS.MAP_OBJECT DEBUG                                    NO  DBA SYS.MAP_OBJECT DELETE                                   NO  DBA SYS.MAP_OBJECT FLASHBACK                                NO  DBA OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ SYS.MAP_OBJECT INSERT                                   NO  DBA SYS.MAP_OBJECT ON COMMIT REFRESH                        NO  DBA SYS.MAP_OBJECT QUERY REWRITE                            NO  DBA OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ SYS.MAP_OBJECT SELECT                                   NO  DBA SYS.MAP_OBJECT SELECT                                   NO  SELECT_CATALOG_ROLE SYS.MAP_OBJECT UPDATE                                   NO  DBA OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ SYS.PS$ DEBUG                                    NO  DBA SYS.PS$ SELECT                                   NO  DBA SYS.RE$NV_LIST EXECUTE                                  NO  PUBLIC OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ SYS.STANDARD EXECUTE                                  NO  PUBLIC SYS.STMT_AUDIT_OPTION_MAP SELECT                                   NO  PUBLIC SYS.SYSTEM_PRIVILEGE_MAP SELECT                                   YES PUBLIC OBJ ------------------------------------------------------------- WHAT_GRANTED                             GRA GRANTEE ---------------------------------------- --- ------------------------------ SYS.TABLE_PRIVILEGE_MAP SELECT                                   YES PUBLIC 49 rows selected. SQL>