{"id":11,"date":"2013-10-24T14:24:00","date_gmt":"2013-10-24T14:24:00","guid":{"rendered":"http:\/\/anjo.pt\/wp\/keyword-oracle\/2013\/10\/24\/oracle-dba-role-granted-privileges-per-version\/"},"modified":"2015-11-17T20:27:23","modified_gmt":"2015-11-17T19:27:23","slug":"oracle-dba-role-granted-privileges-per-version","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2013\/10\/24\/oracle-dba-role-granted-privileges-per-version\/","title":{"rendered":"Oracle DBA role granted privileges per version"},"content":{"rendered":"
\nBelow you can find the Oracle defaults
\nDBA 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).<\/o:p><\/span><\/div>\n
\n<\/div>\n
\nOn Oracle
\n12.1 there are 3 new roles : CAPTURE_ADMIN, EM_EXPRESS_ALL and
\nOPTIMIZER_PROCESSING_RATE. Comments about these new roles\/privileges can be found below.<\/o:p><\/span><\/div>\n
\n<\/div>\n

<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
\n<\/div>\n<\/td>\n
\n
\nadmin_option<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\ncomment<\/o:p><\/span><\/div>\n<\/td>\n<\/tr>\n
\n
\nCAPTURE_ADMIN<\/o:p><\/span><\/div>\n<\/td>\n
\n
\nyes<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n>12.1<\/o:p><\/span><\/div>\n<\/td>\n
\n
\nProvides
\n the privileges necessary to create and manage privilege analysis policies.<\/o:p><\/span><\/div>\n<\/td>\n<\/tr>\n
\n
\nDATAPUMP_EXP_FULL_DATABASE<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n>11.1<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n
\n
\nDATAPUMP_IMP_FULL_DATABASE<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n>11.1<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n
\n
\nDELETE_CATALOG_ROLE<\/o:p><\/span><\/div>\n<\/td>\n
\n
\nyes<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n
\n
\nEM_EXPRESS_ALL<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n>12.1<\/o:p><\/span><\/div>\n<\/td>\n
\n
\nEnables
\n users to connect to Oracle Enterprise Manager (EM) Express and use all the
\n functionality provided by EM Express (read and write access to all EM Express
\n features). The EM_EXPRESS_ALL role includes the EM_EXPRESS_BASIC role<\/o:p><\/span><\/div>\n<\/td>\n<\/tr>\n
\n
\nEXECUTE_CATALOG_ROLE<\/o:p><\/span><\/div>\n<\/td>\n
\n
\nyes<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n
\n
\nEXP_FULL_DATABASE<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n
\n
\nGATHER_SYSTEM_STATISTICS<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n
\n
\nIMP_FULL_DATABASE<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n
\n
\nJAVA_ADMIN<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n
\n
\nJAVA_DEPLOY<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n
\n
\nOPTIMIZER_PROCESSING_RATE<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n>12.1<\/o:p><\/span><\/div>\n<\/td>\n
\n\n\n\n\n\n\n\n\n\n
\n
\nProvides privileges to execute the
\n GATHER_PROCESSING_RATE, SET_PROCESSING_RATE, and DELETE_PROCESSING_RATE
\n procedures in the DBMS_STATS package. These procedures manage the
\n processing rate of a system for automatic degree of parallelism (Auto DOP).
\n Auto DOP uses these processing rates to determine the optimal degree of
\n parallelism for a SQL statement.<\/o:p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n<\/o:p><\/span><\/div>\n<\/td>\n<\/tr>\n
\n
\nSCHEDULER_ADMIN<\/o:p><\/span><\/div>\n<\/td>\n
\n
\nyes<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n
\n
\nSELECT_CATALOG_ROLE<\/o:p><\/span><\/div>\n<\/td>\n
\n
\nyes<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n
\n
\nWM_ADMIN_ROLE<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n
\n
\nXDBADMIN<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n
\n
\nXDB_SET_INVOKER<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n>11.1<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n
\n
\nXDBWEBSERVICES<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n
\n
\n<10.2<\/o:p><\/span><\/div>\n<\/td>\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/p>\n

\nThe query used is:<\/div>\n
\n
\nset pages 20 lines 200<\/span><\/div>\n
\ncol grantee for a10<\/span><\/div>\n
\ncol granted_role for a40<\/span><\/div>\n
\nselect * from dba_role_privs where grantee=’DBA’ order by 1,2;<\/span><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

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). 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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,8,2,7,9],"tags":[],"class_list":{"0":"post-11","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-oracle","7":"category-oracle-10g","8":"category-oracle-11g","9":"category-oracle-12c","10":"category-security","11":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/11","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=11"}],"version-history":[{"count":1,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/11\/revisions"}],"predecessor-version":[{"id":160,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/11\/revisions\/160"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=11"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=11"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=11"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}