Below you can find the Oracle defaults
DBA role privileges per database version since Oracle 10.2. It is based on Enterprise Edition with Java and XML installed (on 12.1 you cannot anymore choose what to install).
DBA role privileges per database version since Oracle 10.2. It is based on Enterprise Edition with Java and XML installed (on 12.1 you cannot anymore choose what to install).
On Oracle
12.1 there are 3 new roles : CAPTURE_ADMIN, EM_EXPRESS_ALL and
OPTIMIZER_PROCESSING_RATE. Comments about these new roles/privileges can be found below.
12.1 there are 3 new roles : CAPTURE_ADMIN, EM_EXPRESS_ALL and
OPTIMIZER_PROCESSING_RATE. Comments about these new roles/privileges can be found below.
|
|
admin_option
|
|
comment
|
|
|
CAPTURE_ADMIN
|
yes
|
>12.1
|
Provides
the privileges necessary to create and manage privilege analysis policies. |
|
|
DATAPUMP_EXP_FULL_DATABASE
|
|
>11.1
|
|
|
|
DATAPUMP_IMP_FULL_DATABASE
|
|
>11.1
|
|
|
|
DELETE_CATALOG_ROLE
|
yes
|
|
|
|
|
EM_EXPRESS_ALL
|
|
>12.1
|
Enables
users to connect to Oracle Enterprise Manager (EM) Express and use all the functionality provided by EM Express (read and write access to all EM Express features). The EM_EXPRESS_ALL role includes the EM_EXPRESS_BASIC role |
|
|
EXECUTE_CATALOG_ROLE
|
yes
|
|
|
|
|
EXP_FULL_DATABASE
|
|
|
|
|
|
GATHER_SYSTEM_STATISTICS
|
|
|
|
|
|
IMP_FULL_DATABASE
|
|
|
|
|
|
JAVA_ADMIN
|
|
|
|
|
|
JAVA_DEPLOY
|
|
|
|
|
|
OPTIMIZER_PROCESSING_RATE
|
|
>12.1
|
|
|
|
SCHEDULER_ADMIN
|
yes
|
|
|
|
|
SELECT_CATALOG_ROLE
|
yes
|
|
|
|
|
WM_ADMIN_ROLE
|
|
|
|
|
|
XDBADMIN
|
|
|
|
|
|
XDB_SET_INVOKER
|
|
>11.1
|
|
|
|
XDBWEBSERVICES
|
|
<10.2
|
|
The query used is:
set pages 20 lines 200
col grantee for a10
col granted_role for a40
select * from dba_role_privs where grantee=’DBA’ order by 1,2;