{"id":2694,"date":"2013-08-09T09:12:00","date_gmt":"2013-08-09T07:12:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/"},"modified":"2013-08-09T09:12:00","modified_gmt":"2013-08-09T07:12:00","slug":"oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/","title":{"rendered":"Oracle Database 12c new features: segregation of duties with new administrative roles"},"content":{"rendered":"<p><img decoding=\"async\" class=\"blog-image aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg\" alt=\"\" \/><\/p>\n<p>Starting with Oracle Database 12c Release 1, Oracle has introduced a set of more task-oriented new administrative privileges. Prior to Oracle 12c you had to have the SYSDBA privilege to make a backup, monitor the Data Guard status, or administrate certain features of Oracle Transparent Data Encryption. With Oracle 12c Release 1, this is not the case anymore. You can now grant limited administrative privileges for the operating of a Oracle 12c database.<\/p>\n<p>This new feature can already be seen during the Oracle 12c installation process. Indeed, during the binary installation, Oracle asks for the granting of privileges to the following groups:<\/p>\n<p><img decoding=\"async\" class=\"caption\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"Oracle 12.1 Administrative Roles during Installatio\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/segregationduties12c.png\" alt=\"Oracle 12.1 Administrative Roles during Installation\" \/><\/p>\n<p>Despite the fact that we still have the possibility to provide only one group for each of these entries, Oracle recommends to provide a unique group to designate each privilege.<\/p>\n<p>Among these new administrative privileges, one can find the following:<\/p>\n<table style=\"width: 600px; margin-left: auto; margin-right: auto;\" border=\"1\">\n<tbody>\n<tr>\n<td><strong>OS Group<\/strong><\/td>\n<td><strong>Database Privilege<\/strong><\/td>\n<td><strong>Short description<\/strong><\/td>\n<\/tr>\n<tr>\n<td>backupdba<\/td>\n<td>SYSBACKUP<\/td>\n<td>This group allows operating system users to have a limited set of database backup and recovery related administrative privileges<\/td>\n<\/tr>\n<tr>\n<td>dgdba<\/td>\n<td>SYSDG<\/td>\n<td>This group allows a group of operating sytem users to have a limited set of privileges to administer and monitor Oracle Data Guard<\/td>\n<\/tr>\n<tr>\n<td>kmdba<\/td>\n<td>SYSKM<\/td>\n<td>This allows operating sytem users to have a limited set of privileges for encryption key management such as Oracle Wallet Manager management, since, by default,\u00a0Oracle 12c encapsulates features such as database vault<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Of course, in order to grant these privileges to users you will have to know exactly what is behind these new administrative privileges. You can find the operations allowed for each of these administrative privileges below:<\/p>\n<h3>SYSBACKUP<\/h3>\n<ul>\n<li>STARTUP<\/li>\n<li>SHUTDOWN<\/li>\n<li>ALTER DATABASE<\/li>\n<li>ALTER SYSTEM<\/li>\n<li>ALTER SESSION<\/li>\n<li>ALTER TABLESPACE<\/li>\n<li>CREATE CONTROLFILE<\/li>\n<li>CREATE ANY DIRECTORY<\/li>\n<li>CREATE ANY TABLE<\/li>\n<li>CREATE ANY CLUSTER<\/li>\n<li>CREATE PFILE<\/li>\n<li>CREATE RESTORE POINT (including GUARANTEED restore points)<\/li>\n<li>CREATE SESSION<\/li>\n<li>CREATE SPFILE<\/li>\n<li>DROP DATABASE<\/li>\n<li>DROP TABLESPACE<\/li>\n<li>DROP RESTORE POINT (including GUARANTEED restore points)<\/li>\n<li>FLASHBACK DATABASE<\/li>\n<li>RESUMABLE<\/li>\n<li>UNLIMITED TABLESPACE<\/li>\n<li>SELECT ANY DICTIONARY<\/li>\n<li>SELECT ANY TRANSACTION<\/li>\n<li>SELECT\n<ul>\n<li>X$ tables (that is, the fixed tables)<\/li>\n<li>V$ and GV$ views (that is, the dynamic performance views)<\/li>\n<li>APPQOSSYS.WLM_CLASSIFIER_PLAN<\/li>\n<li>SYSTEM.LOGSTDBY$PARAMETERS<\/li>\n<\/ul>\n<\/li>\n<li>DELETE\/INSERT\n<ul>\n<li>SYS.APPLY$_SOURCE_SCHEMA<\/li>\n<li>SYSTEM.LOGSTDBY$PARAMETERS<\/li>\n<\/ul>\n<\/li>\n<li>EXECUTE\n<ul>\n<li>SYS.DBMS_BACKUP_RESTORE<\/li>\n<li>SYS.DBMS_RCVMAN<\/li>\n<li>SYS.DBMS_DATAPUMP<\/li>\n<li>SYS.DBMS_IR<\/li>\n<li>SYS.DBMS_PIPE<\/li>\n<li>SYS.SYS_ERROR<\/li>\n<li>SYS.DBMS_TTS<\/li>\n<li>SYS.DBMS_TDB<\/li>\n<li>SYS.DBMS_PLUGTS<\/li>\n<li>SYS.DBMS_PLUGTSP<\/li>\n<\/ul>\n<\/li>\n<li>SELECT_CATALOG_ROLE<\/li>\n<\/ul>\n<h3>SYSDG<\/h3>\n<ul>\n<li>STARTUP<\/li>\n<li>SHUTDOWN<\/li>\n<li>ALTER DATABASE<\/li>\n<li>ALTER SESSION<\/li>\n<li>ALTER SYSTEM<\/li>\n<li>CREATE RESTORE POINT (including GUARANTEED restore points)<\/li>\n<li>CREATE SESSION<\/li>\n<li>DROP RESTORE POINT (including GUARANTEED restore points)<\/li>\n<li>FLASHBACK DATABASE<\/li>\n<li>SELECT ANY DICTIONARY<\/li>\n<li>SELECT\n<ul>\n<li>X$ tables (that is, the fixed tables)<\/li>\n<li>V$ and GV$ views (that is, the dynamic performance views)<\/li>\n<li>APPQOSSYS.WLM_CLASSIFIER_PLAN<\/li>\n<\/ul>\n<\/li>\n<li>DELETE\n<ul>\n<li>APPQOSSYS.WLM_CLASSIFIER_PLAN<\/li>\n<\/ul>\n<\/li>\n<li>EXECUTE\n<ul>\n<li>SYS.DBMS_DRS<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3>SYSKM<\/h3>\n<ul>\n<li>ADMINISTER KEY MANAGEMENT<\/li>\n<li>CREATE SESSION<\/li>\n<li>SELECT (only when database is open)\n<ul>\n<li>SYS.V$ENCRYPTED_TABLESPACES<\/li>\n<li>SYS.V$ENCRYPTION_WALLET<\/li>\n<li>SYS.V$WALLET<\/li>\n<li>SYS.V$ENCRYPTION_KEYS<\/li>\n<li>SYS.V$CLIENT_SECRETS<\/li>\n<li>SYS.DBA_ENCRYPTION_KEY_USAGE<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3>Tests<\/h3>\n<p>In order to illustrate the usage of this new feature, let\u2019s connect with an operating system user who is member of the backupdba operating system group and change the sga_target parameter:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"><code><\/code>oracle@vmtestoel01:\/home\/oracle\/ [SOUK] id grs\nuid=54323(grs) gid=54324(backupdba) groups=54324(backupdba)\n\noracle@vmtestoel01:\/home\/oracle\/ [SOUK] su - grs\n\ngrs@vmtestoel01:\/home\/grs\/ [SOUK]\u00a0 sqlplus \/ as sysbackup\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit\nSQL&gt; alter system set sga_target=800M;\nSystem altered.<\/pre>\n<p>Now, let&#8217;s try to drop a tablespace with a user (in our case &#8220;her&#8221;) who is a member of the dgdba operating system group (SYSDG). This user should not be allowed to perform such an operation since the privilege &#8220;drop tablespace&#8221; is not in the SYSDG group.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">[root@vmtestoel01 ~]# id her\nuid=54324(her) gid=54325(dgdba) groups=54325(dgdba)\n\u00a0\noracle@vmtestoel01:\/home\/oracle\/ [SOUK] su - her\n\u00a0\nher@vmtestoel01:\/home\/her\/ [SOUK]\u00a0 sqlplus \/as sysdg\nOracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit\nSQL&gt; drop tablespace temp including contents and datafiles;\ndrop tablespace temp including contents and datafiles\n*\nERROR at line 1:\nORA-01031: insufficient privileges<\/pre>\n<p>As expected, the user &#8220;her&#8221; was not allowed to drop a tablespace, since SYSDG is not allowed to perform such an operation.<\/p>\n<h3>Conclusion<\/h3>\n<p>I think this new feature will be very valuable and appreciated especially in an environment where a strong segregation of duties is made. However, the usage of this new feature is not mandatory since Oracle allows to use the same OS group (for instance dba) for each administrative group.<\/p>\n<p>Have fun with Oracle 12c Release 1!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Starting with Oracle Database 12C Release 1 a set of new administrative privileges that are more task oriented are available.<\/p>\n<p>Before Oracle 12c it was needed to have the SYSDBA privilege to make a backup, to monitor the Data Guard status or to administrate some features of Oracle Transparent Data Encryption. Starting with this new Oracle release it is not anymore the case. We can grant limited administrative privileges to operate an Oracle 12c database.<\/p>\n","protected":false},"author":10,"featured_media":2695,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[23,101,209],"class_list":["post-2694","post","type-post","status-publish","format-standard","has-post-thumbnail","category-database","tag-dba","tag-installation","tag-oracle-12c"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Oracle Database 12c new features: segregation of duties with new administrative roles - dbi services Blog<\/title>\n<meta name=\"description\" content=\"Starting with Oracle Database 12C Release 1, a set of new and more task-oriented administrative privileges are available. This blog describes these privileges and shows how to use them via practical examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database 12c new features: segregation of duties with new administrative roles\" \/>\n<meta property=\"og:description\" content=\"Starting with Oracle Database 12C Release 1, a set of new and more task-oriented administrative privileges are available. This blog describes these privileges and shows how to use them via practical examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2013-08-09T07:12:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"406\" \/>\n\t<meta property=\"og:image:height\" content=\"100\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Gr\u00e9gory Steulet\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gr\u00e9gory Steulet\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\\\/\"},\"author\":{\"name\":\"Gr\u00e9gory Steulet\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/eae2ad4145ad07d92358ce1b4bbd7aff\"},\"headline\":\"Oracle Database 12c new features: segregation of duties with new administrative roles\",\"datePublished\":\"2013-08-09T07:12:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\\\/\"},\"wordCount\":658,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/2e1ax_default_entry_Oracle_Database_12c.jpg\",\"keywords\":[\"DBA\",\"Installation\",\"Oracle 12c\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\\\/\",\"name\":\"Oracle Database 12c new features: segregation of duties with new administrative roles - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/2e1ax_default_entry_Oracle_Database_12c.jpg\",\"datePublished\":\"2013-08-09T07:12:00+00:00\",\"description\":\"Starting with Oracle Database 12C Release 1, a set of new and more task-oriented administrative privileges are available. This blog describes these privileges and shows how to use them via practical examples.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/2e1ax_default_entry_Oracle_Database_12c.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/2e1ax_default_entry_Oracle_Database_12c.jpg\",\"width\":406,\"height\":100},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Database 12c new features: segregation of duties with new administrative roles\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/eae2ad4145ad07d92358ce1b4bbd7aff\",\"name\":\"Gr\u00e9gory Steulet\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/GRS_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/GRS_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/GRS_web-min-scaled.jpg\",\"caption\":\"Gr\u00e9gory Steulet\"},\"description\":\"Gr\u00e9gory Steulet is Partner Manager and CFO at dbi services. He previously served as CFO and COO of the Sequotech Group. Earlier in his career, he spent more than ten years in database and infrastructure management, with experience in Oracle technologies, high availability, Avaloq banking applications and open-source technologies such as MySQL and Unix\\\/Linux. Although his current role is no longer focused on database administration, he continues to share his experience through occasional blog posts. Before joining dbi services, Gr\u00e9gory was a Senior Consultant at Trivadis and an IT Administrator at Box Telecom. He holds an Executive MBA, a Bachelor's degree in Business Administration and Computer Science, and Certificates of Advanced Studies in Mergers and Acquisitions and Data Protection. His industry experience includes telecommunications, financial services, logistics and pharmaceuticals.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/gregory-steulet\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Database 12c new features: segregation of duties with new administrative roles - dbi services Blog","description":"Starting with Oracle Database 12C Release 1, a set of new and more task-oriented administrative privileges are available. This blog describes these privileges and shows how to use them via practical examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Database 12c new features: segregation of duties with new administrative roles","og_description":"Starting with Oracle Database 12C Release 1, a set of new and more task-oriented administrative privileges are available. This blog describes these privileges and shows how to use them via practical examples.","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2013-08-09T07:12:00+00:00","og_image":[{"width":406,"height":100,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","type":"image\/jpeg"}],"author":"Gr\u00e9gory Steulet","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Gr\u00e9gory Steulet","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/"},"author":{"name":"Gr\u00e9gory Steulet","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/eae2ad4145ad07d92358ce1b4bbd7aff"},"headline":"Oracle Database 12c new features: segregation of duties with new administrative roles","datePublished":"2013-08-09T07:12:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/"},"wordCount":658,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","keywords":["DBA","Installation","Oracle 12c"],"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/","name":"Oracle Database 12c new features: segregation of duties with new administrative roles - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","datePublished":"2013-08-09T07:12:00+00:00","description":"Starting with Oracle Database 12C Release 1, a set of new and more task-oriented administrative privileges are available. This blog describes these privileges and shows how to use them via practical examples.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/2e1ax_default_entry_Oracle_Database_12c.jpg","width":406,"height":100},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-new-features-segregation-of-duties-with-new-administrative-roles\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Database 12c new features: segregation of duties with new administrative roles"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/eae2ad4145ad07d92358ce1b4bbd7aff","name":"Gr\u00e9gory Steulet","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/GRS_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/GRS_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/GRS_web-min-scaled.jpg","caption":"Gr\u00e9gory Steulet"},"description":"Gr\u00e9gory Steulet is Partner Manager and CFO at dbi services. He previously served as CFO and COO of the Sequotech Group. Earlier in his career, he spent more than ten years in database and infrastructure management, with experience in Oracle technologies, high availability, Avaloq banking applications and open-source technologies such as MySQL and Unix\/Linux. Although his current role is no longer focused on database administration, he continues to share his experience through occasional blog posts. Before joining dbi services, Gr\u00e9gory was a Senior Consultant at Trivadis and an IT Administrator at Box Telecom. He holds an Executive MBA, a Bachelor's degree in Business Administration and Computer Science, and Certificates of Advanced Studies in Mergers and Acquisitions and Data Protection. His industry experience includes telecommunications, financial services, logistics and pharmaceuticals.","url":"https:\/\/www.dbi-services.com\/blog\/author\/gregory-steulet\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2694","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2694"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2694\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2695"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}