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

system privilege

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759474372, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/security/roles/oracle-maintained/index(111): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78