Oracle Predefined Roles
What is user role? An user role is a set of related privileges which are required to perform some aspect of tasks, so you don't need to grant each of every privilege to users, you can just grant the role to users who need those privileges.
Oracle predefined roles are originally provided by default ever since database created, who are practically used for some specific tasks, for example, IMP_FULL_DATABASE role.
Here are the list of Oracle predefined roles.
- ACCHK_READ
- ADM_PARALLEL_EXECUTE_TASK
- AQ_ADMINISTRATOR_ROLE
- AQ_USER_ROLE
- AUDIT_ADMIN
- AUDIT_VIEWER
- AUTHENTICATEDUSER
- CAPTURE_ADMIN
- CDB_DBA
- CONNECT
- CTXAPP
- CWM_USER
- DATAPUMP_EXP_FULL_DATABASE
- DATAPUMP_IMP_FULL_DATABASE
- DBA
- DBFS_ROLE
- EJBCLIENT
- EM_EXPRESS_ALL
- EM_EXPRESS_BASIC
- EXECUTE_CATALOG_ROLE
- EXP_FULL_DATABASE
- GATHER_SYSTEM_STATISTICS
- GLOBAL_AQ_USER_ROLE
- HS_ADMIN_EXECUTE_ROLE
- HS_ADMIN_ROLE
- HS_ADMIN_SELECT_ROLE
- IMP_FULL_DATABASE
- JAVADEBUGPRIV
- JAVAIDPRIV
- JAVASYSPRIV
- JAVAUSERPRIV
- JAVA_ADMIN
- JMXSERVER
- LBAC_DBA
- LOGSTDBY_ADMINISTRATOR
- OEM_ADVISOR
- OEM_MONITOR
- OLAP_DBA
- OLAP_USER
- OLAP_XS_ADMIN
- OPTIMIZER_PROCESSING_RATE
- PDB_DBA
- PROVISIONER
- RECOVERY_CATALOG_OWNER
- RESOURCE
- SCHEDULER_ADMIN
- SELECT_CATALOG_ROLE
- SODA_APP
- WM_ADMIN_ROLE
- XDBADMIN
- XDB_SET_INVOKER
- XDB_WEBSERVICES
- XDB_WEBSERVICES_OVER_HTTP
- XDB_WEBSERVICES_WITH_PUBLIC
- XS_CACHE_ADMIN
- XS_NSATTR_ADMIN
- XS_RESOURCE
- XS_SESSION_ADMIN