Search notes:

Oracle maintained roles

Oracle maintained roles can be queried from dba_roles by limiting the result set with where oracle_maintained = 'Y': 
select
   role
from
   dba_roles
where
   oracle_maintained = 'Y'
order by
   role;
ADM_PARALLEL_EXECUTE_TASK
APPLICATION_TRACE_VIEWER
AQ_ADMINISTRATOR_ROLE
AQ_USER_ROLE
AUDIT_ADMIN
AUDIT_VIEWER
AUTHENTICATEDUSER
BDSQL_ADMIN
BDSQL_USER
CAPTURE_ADMIN
CDB_DBA
CONNECT
CTXAPP
DATAPATCH_ROLE
DATAPUMP_EXP_FULL_DATABASE
DATAPUMP_IMP_FULL_DATABASE
DBA
DBFS_ROLE
DBMS_MDX_INTERNAL
DELETE_CATALOG_ROLE
EM_EXPRESS_ALL
EM_EXPRESS_BASIC
EXECUTE_CATALOG_ROLE
EXP_FULL_DATABASE
GATHER_SYSTEM_STATISTICS
GDS_CATALOG_SELECT
GGSYS_ROLE
GLOBAL_AQ_USER_ROLE
GSMADMIN_ROLE
GSMROOTUSER_ROLE
GSMUSER_ROLE
GSM_POOLADMIN_ROLE
HS_ADMIN_EXECUTE_ROLE
HS_ADMIN_ROLE
HS_ADMIN_SELECT_ROLE
IMP_FULL_DATABASE
LOGSTDBY_ADMINISTRATOR
OEM_ADVISOR
OEM_MONITOR
OPTIMIZER_PROCESSING_RATE
ORACLE_JAVA_DEV
PDB_DBA
PROVISIONER
RECOVERY_CATALOG_OWNER
RECOVERY_CATALOG_OWNER_VPD
RECOVERY_CATALOG_USER
RESOURCE
SCHEDULER_ADMIN
SELECT_CATALOG_ROLE
SODA_APP
SYSUMF_ROLE
WM_ADMIN_ROLE
XDBADMIN
XDB_SET_INVOKER
XDB_WEBSERVICES
XDB_WEBSERVICES_OVER_HTTP
XDB_WEBSERVICES_WITH_PUBLIC
XS_CACHE_ADMIN
XS_CONNECT
XS_NAMESPACE_ADMIN
XS_SESSION_ADMIN

See also

Oracle: System privileges

Index