Query dba_roles : dba_roles « System Tables Views « Oracle PL / SQL






Query dba_roles

 
SQL>
SQL> select role, password_required
  2  from dba_roles
  3  where rownum < 50
  4  order by role
  5  /
ROLE                           PASSWORD
------------------------------ --------
AQ_ADMINISTRATOR_ROLE          NO
AQ_USER_ROLE                   NO
AUTHENTICATEDUSER              NO
CONNECT                        NO
CTXAPP                         NO
DBA                            NO
DELETE_CATALOG_ROLE            NO
EXECUTE_CATALOG_ROLE           NO
EXP_FULL_DATABASE              NO
GATHER_SYSTEM_STATISTICS       NO
HS_ADMIN_ROLE                  NO
IMP_FULL_DATABASE              NO
LOGSTDBY_ADMINISTRATOR         NO
OEM_ADVISOR                    NO
OEM_MONITOR                    NO
PLUSTRACE                      NO
RECOVERY_CATALOG_OWNER         NO
RESOURCE                       NO
SCHEDULER_ADMIN                NO
SELECT_CATALOG_ROLE            NO
XDBADMIN                       NO
XDBWEBSERVICES                 NO

22 rows selected.

SQL> --

 








Related examples in the same category