> desc dba_role_privs
Name Null? Type
----------------------------------------- -------- ----------------------------
GRANTEE VARCHAR2(30)
GRANTED_ROLE NOT NULL VARCHAR2(30)
ADMIN_OPTION VARCHAR2(3)
DEFAULT_ROLE VARCHAR2(3)
>
> Select count(*) from dba_role_privs
2 where grantee = 'SYSTEM';
COUNT(*)
----------
20
> SELECT granted_role, default_role FROM dba_role_privs
2 WHERE grantee = 'SYSTEM';
GRANTED_ROLE DEF
------------------------------ ---
DBA YES
QA_ROLE YES
AC_OWNER YES
RG_0_ROLE YES
RG_1_ROLE YES
RG_2_ROLE YES
RG_R_ROLE YES
ADMIN_ROLE YES
LOGIN_ROLE YES
FUSION_ROLE YES
INITIAL_ROLE YES
GRANTED_ROLE DEF
------------------------------ ---
DISTRIB_0_ROLE YES
DISTRIB_1_ROLE YES
DISTRIB_2_ROLE YES
DISTRIB_E_ROLE YES
DISTRIB_R_ROLE YES
INST_ADMIN_ROLE YES
SBS_LOADER_ROLE YES
SHIP_QUERY_ROLE YES
AQ_ADMINISTRATOR_ROLE YES
20 rows selected.
> SHOW parameter MAX_ENABLED
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_enabled_roles integer 30
>
>
>
> connect system
Enter password:
ERROR:
ORA-01925: maximum of 30 enabled roles exceeded
Warning: You are no longer connected to ORACLE.
>
>
> show user
USER is ""
>