查看用户信息及角色

set line 132
set wrap off 
set pagesize 49999
col USERNAME for a10
col DEFAULT_TABLESPACE for a15
col TEMPORARY_TABLESPACE for a15
col PROFILE for a10

SELECT username,default_tablespace,temporary_tablespace,profile,granted_role,
admin_option,default_role FROM sys.dba_users a, sys.dba_role_privs b
WHERE a.username = b.grantee ORDER BY username,default_tablespace,
temporary_tablespace,profile,granted_role ;
 
  USERNAME   DEFAULT_TABLESP TEMPORARY_TABLE PROFILE    GRANTED_ROLE                   ADM DEF
---------- --------------- --------------- ---------- ------------------------------ --- ---
ADMIN      USERS           TEMP            DEFAULT    AQ_ADMINISTRATOR_ROLE          NO  YES
ADMIN      USERS           TEMP            DEFAULT    AQ_USER_ROLE                   NO  YES
ADMIN      USERS           TEMP            DEFAULT    CONNECT                        NO  YES
ADMIN      USERS           TEMP            DEFAULT    DBA                            NO  YES
ADMIN      USERS           TEMP            DEFAULT    RESOURCE                       NO  YES
CTXSYS     SYSAUX          TEMP            DEFAULT    CTXAPP                         YES YES
CTXSYS     SYSAUX          TEMP            DEFAULT    RESOURCE                       NO  YES
DBSNMP     SYSAUX          TEMP            DEFAULT    OEM_MONITOR                    NO  YES
EXFSYS     SYSAUX          TEMP            DEFAULT    CONNECT                        NO  YES