oracle 查询所有的角色sql语句 在线等

Question

oracle 查询所有的角色sql语句 在线等

Answer 1

select * from all_rules

Answer 2

select * from dba_roles;

Answer 3

oracle 10g
SQL> desc dba_roles;
Name              Type         Nullable Default Comments                                                
----------------- ------------ -------- ------- ------------------------------------------------------- 
ROLE              VARCHAR2(30)                  Role Name                                               
PASSWORD_REQUIRED VARCHAR2(8)  Y                Indicates if the role requires a password to be enabled 
ROLE                           PASSWORD_REQUIRED
------------------------------ -----------------
CONNECT                        NO
RESOURCE                       NO
DBA                            NO
SELECT_CATALOG_ROLE            NO
EXECUTE_CATALOG_ROLE           NO
DELETE_CATALOG_ROLE            NO
EXP_FULL_DATABASE              NO
IMP_FULL_DATABASE              NO
RECOVERY_CATALOG_OWNER         NO
GATHER_SYSTEM_STATISTICS       NO
LOGSTDBY_ADMINISTRATOR         NO
AQ_ADMINISTRATOR_ROLE          NO
AQ_USER_ROLE                   NO
GLOBAL_AQ_USER_ROLE            GLOBAL
SCHEDULER_ADMIN                NO
HS_ADMIN_ROLE                  NO
CTXAPP                         NO
OEM_MONITOR                    NO
WM_ADMIN_ROLE                  NO
JAVAUSERPRIV                   NO
JAVAIDPRIV                     NO
JAVASYSPRIV                    NO
JAVADEBUGPRIV                  NO
EJBCLIENT                      NO
JAVA_ADMIN                     NO
JAVA_DEPLOY                    NO
DMUSER_ROLE                    NO
DM_CATALOG_ROLE                NO
XDBADMIN                       NO
AUTHENTICATEDUSER              NO
OLAP_DBA                       NO
OLAP_USER                      NO
WKUSER                         NO
MGMT_USER                      NO
 
34 rows selected

Answer 4

select * from dba_roles;

Answer 5

select * from dba_roles;

Answer 6

select * from dba_roles;

Answer 7

查看所有角色select * from dba_roles;查看用户所拥有的角色select * from dba_role_privs;select * from user_role_privs;

Answer 8

select * from dba_roles;