{"id":2052,"date":"2015-12-22T00:16:04","date_gmt":"2015-12-22T02:16:04","guid":{"rendered":"http:\/\/www.dbarj.com.br\/en\/?p=2052"},"modified":"2015-12-22T00:16:50","modified_gmt":"2015-12-22T02:16:50","slug":"creating-role-for-dbaas-in-oracle-enterprise-manager-cloud","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/","title":{"rendered":"Creating ROLE for DBaaS in Oracle Enterprise Manager Cloud"},"content":{"rendered":"

Creating a ROLE for DBaaS<\/strong> in\u00a0Oracle Enterprise Manager Cloud is necessary for some tasks like when you want to setup DBaaS quotas.\u00a0Quota is not required for initial set up but users would have no restrictions by default.<\/p>\n

When you open the “Create New Quota<\/strong>” screen, you will notice that no role is shown. Also, if you try to create an empty simple role without any sub-role or privileges granted, this role will not be presented\u00a0neither, like the image below:
\n\"\"
\nActually, to create a role for DBaaS, you need to do some customization. So let’s do it.<\/p>\n

Go to the create role screen on “Setup->Security->Roles<\/strong>“. Click on “Create<\/strong>“.<\/p>\n

Give the role a name and go to the next screen:
\n\"\"
\nDo not\u00a0grant any role to it. Click “Next<\/strong>“:
\n\"\"
\nIn the\u00a0“Target Privileges<\/strong>” step, do not select anything. Click “Next<\/strong>“.<\/p>\n

The “Resource Privileges<\/strong>” screen is where you need some extra attention. Edit the “Cloud Self Service Portal<\/strong>” item. Add the option to “Access Cloud Self Service Portal<\/strong>“:
\n\"\"
\nThe item will be added like below:
\n\"\"
\nIn the “Administrators<\/strong>” step, do not select anything. Click “Next<\/strong>” and review.\u00a0Finally, click “Finish<\/strong>” to create the new role:
\n\"\"
\nIf you try now to add a new\u00a0quota, you will be able to see the role available:
\n\"\"
\nThat’s it. Hope you enjoyed.<\/p>\n

P.S: Another option would be creating the role with the “EM_SSA_USER<\/strong>” or “EM_SSA_USER_BASE<\/strong>” as granted roles. The problem with this approach is that you may be giving more privileges than needed.<\/p>\nHave you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n

Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,43],"tags":[],"class_list":["post-2052","post","type-post","status-publish","format-standard","hentry","category-oem12c-en","category-oracle-cloud-en","item-wrap"],"yoast_head":"\nCreating ROLE for DBaaS in Oracle Enterprise Manager Cloud - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"Creating a ROLE for DBaaS in\u00a0Oracle Enterprise Manager Cloud is necessary for some tasks like when you want to setup DBaaS quotas.\" \/>\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.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/12\\\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/12\\\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"Creating ROLE for DBaaS in Oracle Enterprise Manager Cloud\",\"datePublished\":\"2015-12-22T02:16:04+00:00\",\"dateModified\":\"2015-12-22T02:16:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/12\\\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\\\/\"},\"wordCount\":274,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/12\\\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/img_56787c0f78ed7.png\",\"articleSection\":[\"Enterprise Manager 12c\",\"Oracle Cloud\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/12\\\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/12\\\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/12\\\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\\\/\",\"name\":\"Creating ROLE for DBaaS in Oracle Enterprise Manager Cloud - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/12\\\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/12\\\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/img_56787c0f78ed7.png\",\"datePublished\":\"2015-12-22T02:16:04+00:00\",\"dateModified\":\"2015-12-22T02:16:50+00:00\",\"description\":\"Creating a ROLE for DBaaS in\u00a0Oracle Enterprise Manager Cloud is necessary for some tasks like when you want to setup DBaaS quotas.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/12\\\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/12\\\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/12\\\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/img_56787c0f78ed7.png\",\"contentUrl\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/img_56787c0f78ed7.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/12\\\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating ROLE for DBaaS in Oracle Enterprise Manager Cloud\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating ROLE for DBaaS in Oracle Enterprise Manager Cloud - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Creating a ROLE for DBaaS in\u00a0Oracle Enterprise Manager Cloud is necessary for some tasks like when you want to setup DBaaS quotas.","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.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"Creating ROLE for DBaaS in Oracle Enterprise Manager Cloud","datePublished":"2015-12-22T02:16:04+00:00","dateModified":"2015-12-22T02:16:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/"},"wordCount":274,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/#primaryimage"},"thumbnailUrl":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2015\/12\/img_56787c0f78ed7.png","articleSection":["Enterprise Manager 12c","Oracle Cloud"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/","url":"https:\/\/www.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/","name":"Creating ROLE for DBaaS in Oracle Enterprise Manager Cloud - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/#primaryimage"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/#primaryimage"},"thumbnailUrl":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2015\/12\/img_56787c0f78ed7.png","datePublished":"2015-12-22T02:16:04+00:00","dateModified":"2015-12-22T02:16:50+00:00","description":"Creating a ROLE for DBaaS in\u00a0Oracle Enterprise Manager Cloud is necessary for some tasks like when you want to setup DBaaS quotas.","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/#primaryimage","url":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2015\/12\/img_56787c0f78ed7.png","contentUrl":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2015\/12\/img_56787c0f78ed7.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2015\/12\/creating-role-for-dbaas-in-oracle-enterprise-manager-cloud\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Creating ROLE for DBaaS in Oracle Enterprise Manager Cloud"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/2052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=2052"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/2052\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=2052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=2052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=2052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}