Skip to content

Oracle Predefined Role List All

  • by

Oracle Default 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_EXRESS_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

Leave a Reply

Your email address will not be published.