查询用户获得的角色
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 |
SQL> col GRANTEE for a32 SQL> col GRANTED_ROLE for a32 SQL> set linesize 300 SQL> set pagesize 300 SQL> SQL> select * from dba_role_privs order by grantee; GRANTEE GRANTED_ROLE ADM DEL DEF COM -------------------------------- -------------------------------- --- --- --- --- APEX_040200 RESOURCE NO NO YES YES APEX_040200 CONNECT NO NO YES YES CTXSYS RESOURCE NO NO YES YES CTXSYS CTXAPP YES NO YES YES DATAPUMP_EXP_FULL_DATABASE EXP_FULL_DATABASE NO NO YES YES DATAPUMP_IMP_FULL_DATABASE IMP_FULL_DATABASE NO NO YES YES DATAPUMP_IMP_FULL_DATABASE EXP_FULL_DATABASE NO NO YES YES DBA XDB_SET_INVOKER NO NO YES YES DBA DATAPUMP_EXP_FULL_DATABASE NO NO YES YES DBA OLAP_XS_ADMIN NO NO YES YES DBA DELETE_CATALOG_ROLE NO NO YES YES DBA EXECUTE_CATALOG_ROLE NO NO YES YES DBA SCHEDULER_ADMIN YES NO YES YES DBA JAVA_DEPLOY NO NO YES YES DBA GATHER_SYSTEM_STATISTICS NO NO YES YES DBA JAVA_ADMIN NO NO YES YES DBA EM_EXPRESS_ALL NO NO YES YES DBA SELECT_CATALOG_ROLE NO NO YES YES DBA EXP_FULL_DATABASE NO NO YES YES DBA WM_ADMIN_ROLE NO NO YES YES DBA CAPTURE_ADMIN NO NO YES YES DBA OPTIMIZER_PROCESSING_RATE NO NO YES YES DBA DATAPUMP_IMP_FULL_DATABASE NO NO YES YES DBA OLAP_DBA NO NO YES YES DBA IMP_FULL_DATABASE NO NO YES YES DBA XDBADMIN NO NO YES YES DBSNMP CDB_DBA NO NO YES YES DBSNMP DV_MONITOR NO NO YES YES DBSNMP OEM_MONITOR NO NO YES YES DVF CONNECT NO NO YES YES DVSYS DV_XSTREAM_ADMIN YES NO YES YES DVSYS DV_OWNER YES NO YES YES DVSYS DV_STREAMS_ADMIN YES NO YES YES DVSYS DV_GOLDENGATE_ADMIN YES NO YES YES DVSYS RESOURCE NO NO YES YES DVSYS DV_DATAPUMP_NETWORK_LINK YES NO YES YES DVSYS DV_PUBLIC YES NO YES YES DVSYS DV_MONITOR YES NO YES YES DVSYS DV_GOLDENGATE_REDO_ACCESS YES NO YES YES DVSYS DV_SECANALYST YES NO YES YES DVSYS DV_ACCTMGR YES NO YES YES DVSYS DV_AUDIT_CLEANUP YES NO YES YES DVSYS CONNECT NO NO YES YES DVSYS DV_ADMIN YES NO YES YES DVSYS DV_PATCH_ADMIN YES NO YES YES DV_ACCTMGR CONNECT YES NO YES YES DV_ADMIN DV_SECANALYST NO NO YES YES DV_OWNER DV_SECANALYST YES NO YES YES DV_OWNER DV_PUBLIC YES NO YES YES DV_OWNER DV_GOLDENGATE_REDO_ACCESS YES NO YES YES DV_OWNER DV_AUDIT_CLEANUP YES NO YES YES DV_OWNER DV_XSTREAM_ADMIN YES NO YES YES DV_OWNER DV_MONITOR YES NO YES YES DV_OWNER DV_STREAMS_ADMIN YES NO YES YES DV_OWNER DV_GOLDENGATE_ADMIN YES NO YES YES DV_OWNER DV_ADMIN YES NO YES YES DV_OWNER DV_PATCH_ADMIN YES NO YES YES DV_OWNER DV_DATAPUMP_NETWORK_LINK YES NO YES YES EM_EXPRESS_ALL EM_EXPRESS_BASIC NO NO YES YES EM_EXPRESS_BASIC SELECT_CATALOG_ROLE NO NO YES YES EXECUTE_CATALOG_ROLE HS_ADMIN_EXECUTE_ROLE NO NO YES YES EXP_FULL_DATABASE EXECUTE_CATALOG_ROLE NO NO YES YES EXP_FULL_DATABASE SELECT_CATALOG_ROLE NO NO YES YES GSMADMIN_ROLE AQ_ADMINISTRATOR_ROLE NO NO YES YES GSMADMIN_ROLE CONNECT NO NO YES YES GSMCATUSER AQ_ADMINISTRATOR_ROLE NO NO YES YES GSMCATUSER CONNECT NO NO YES YES GSMCATUSER GSMADMIN_ROLE NO NO YES YES GSMCATUSER GSM_POOLADMIN_ROLE NO NO YES YES GSMUSER GSMUSER_ROLE NO NO YES YES GSMUSER_ROLE CONNECT NO NO YES YES GSM_POOLADMIN_ROLE CONNECT NO NO YES YES HS_ADMIN_ROLE HS_ADMIN_SELECT_ROLE NO NO YES YES HS_ADMIN_ROLE HS_ADMIN_EXECUTE_ROLE NO NO YES YES IMP_FULL_DATABASE SELECT_CATALOG_ROLE NO NO YES YES IMP_FULL_DATABASE EXECUTE_CATALOG_ROLE NO NO YES YES JAVASYSPRIV JAVAUSERPRIV NO NO YES YES LBACSYS RESOURCE NO NO YES YES LBACSYS LBAC_DBA YES NO YES YES LOGSTDBY_ADMINISTRATOR RESOURCE NO NO YES YES MDDATA CONNECT NO NO YES YES MDDATA RESOURCE NO NO YES YES MDSYS CONNECT NO NO YES YES MDSYS RESOURCE NO NO YES YES OEM_MONITOR SELECT_CATALOG_ROLE NO NO YES YES OJVMSYS RESOURCE NO NO YES YES OLAPSYS OLAP_DBA NO NO YES YES OLAP_XS_ADMIN XS_RESOURCE NO NO YES YES ORDSYS JAVAUSERPRIV NO NO YES YES OUTLN RESOURCE NO NO YES YES RECOVERY_CATALOG_OWNER RECOVERY_CATALOG_USER YES NO YES YES SARA CONNECT NO NO YES NO SARA RESOURCE NO NO YES NO SCOTT RESOURCE NO NO YES NO SCOTT CONNECT NO NO YES NO SELECT_CATALOG_ROLE HS_ADMIN_SELECT_ROLE NO NO YES YES SPATIAL_CSW_ADMIN_USR CONNECT NO NO YES YES SPATIAL_CSW_ADMIN_USR SPATIAL_CSW_ADMIN YES NO YES YES SPATIAL_CSW_ADMIN_USR RESOURCE NO NO YES YES SPATIAL_WFS_ADMIN_USR RESOURCE NO NO YES YES SPATIAL_WFS_ADMIN_USR SPATIAL_WFS_ADMIN YES NO YES YES SPATIAL_WFS_ADMIN_USR CONNECT NO NO YES YES SYS JAVA_DEPLOY YES NO YES YES SYS EJBCLIENT YES NO YES YES SYS JAVASYSPRIV YES NO YES YES SYS XDB_WEBSERVICES YES NO YES YES SYS SCHEDULER_ADMIN YES NO YES YES SYS AQ_USER_ROLE YES NO YES YES SYS LOGSTDBY_ADMINISTRATOR YES NO YES YES SYS PDB_DBA YES NO YES YES SYS CDB_DBA YES NO YES YES SYS EXECUTE_CATALOG_ROLE YES NO YES YES SYS RESOURCE YES NO YES YES SYS XDB_WEBSERVICES_WITH_PUBLIC YES NO YES YES SYS OEM_ADVISOR YES NO YES YES SYS EM_EXPRESS_ALL YES NO YES YES SYS GATHER_SYSTEM_STATISTICS YES NO YES YES SYS SELECT_CATALOG_ROLE YES NO YES YES SYS CONNECT YES NO YES YES SYS JMXSERVER YES NO YES YES SYS XDB_SET_INVOKER YES NO YES YES SYS XDBADMIN YES NO YES YES SYS IMP_FULL_DATABASE YES NO YES YES SYS APEX_GRANTS_FOR_NEW_USERS_ROLE YES NO YES YES SYS APEX_ADMINISTRATOR_ROLE YES NO YES YES SYS JAVADEBUGPRIV YES NO YES YES SYS JAVAIDPRIV YES NO YES YES SYS EM_EXPRESS_BASIC YES NO YES YES SYS RECOVERY_CATALOG_USER YES NO YES YES SYS RECOVERY_CATALOG_OWNER YES NO YES YES SYS OPTIMIZER_PROCESSING_RATE YES NO YES YES SYS XS_SESSION_ADMIN YES NO YES YES SYS XS_RESOURCE YES NO YES YES SYS GSMUSER_ROLE YES NO YES YES SYS DELETE_CATALOG_ROLE YES NO YES YES SYS DV_REALM_OWNER YES NO YES YES SYS CSW_USR_ROLE YES NO YES YES SYS OLAP_XS_ADMIN YES NO YES YES SYS CAPTURE_ADMIN YES NO YES YES SYS DBA YES NO YES YES SYS WFS_USR_ROLE YES NO YES YES SYS JAVAUSERPRIV YES NO YES YES SYS GDS_CATALOG_SELECT YES NO YES YES SYS GSM_POOLADMIN_ROLE YES NO YES YES SYS GSMADMIN_ROLE YES NO YES YES SYS XDB_WEBSERVICES_OVER_HTTP YES NO YES YES SYS AUTHENTICATEDUSER YES NO YES YES SYS XS_CACHE_ADMIN YES NO YES YES SYS ADM_PARALLEL_EXECUTE_TASK YES NO YES YES SYS DV_REALM_RESOURCE YES NO YES YES SYS OLAP_DBA YES NO YES YES SYS ORDADMIN YES NO YES YES SYS HS_ADMIN_ROLE YES NO YES YES SYS HS_ADMIN_SELECT_ROLE YES NO YES YES SYS XS_NAMESPACE_ADMIN YES NO YES YES SYS DATAPUMP_IMP_FULL_DATABASE YES NO YES YES SYS EXP_FULL_DATABASE YES NO YES YES SYS AUDIT_VIEWER YES NO YES YES SYS AUDIT_ADMIN YES NO YES YES SYS SPATIAL_CSW_ADMIN YES NO YES YES SYS CTXAPP YES NO YES YES SYS JAVA_ADMIN YES NO YES YES SYS OEM_MONITOR YES NO YES YES SYS HS_ADMIN_EXECUTE_ROLE YES NO YES YES SYS PROVISIONER YES NO YES YES SYS DATAPUMP_EXP_FULL_DATABASE YES NO YES YES SYS AQ_ADMINISTRATOR_ROLE YES NO YES YES SYS DBFS_ROLE YES NO YES YES SYS LBAC_DBA YES NO YES YES SYS SPATIAL_WFS_ADMIN YES NO YES YES SYS OLAP_USER YES NO YES YES SYSBACKUP SELECT_CATALOG_ROLE NO NO YES YES SYSTEM DBA NO NO YES YES SYSTEM AQ_ADMINISTRATOR_ROLE YES NO YES YES WMSYS WM_ADMIN_ROLE YES NO YES YES XDB DBFS_ROLE NO NO YES YES XDB CTXAPP NO NO YES YES XDB RESOURCE NO NO YES YES 178 rows selected. SQL> |
————————————————————————————
Ending。