{"id":2632,"date":"2017-06-07T09:00:22","date_gmt":"2017-06-07T12:00:22","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=2632\/"},"modified":"2017-06-07T09:06:12","modified_gmt":"2017-06-07T12:06:12","slug":"ocm-12c-preparation-create-and-manage-users-roles-and-privileges","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\/","title":{"rendered":"OCM 12c Preparation &#8211; Create and manage users, roles, and privileges"},"content":{"rendered":"<p>Creating users, roles and give them privileges are one of the most basic thing a DBA must know. If you need to create any in the exam, you need to memorialize the syntax because this type of task is so basic that you can&#8217;t lose time on it.<\/p>\n<p>As in 12c we have now common and local users, this is the main point you need to understand the difference and play creating and granting privileges on the PDB or the CDB.<\/p>\n<p>You must clearly know:<\/p>\n<ul>\n<li><span style=\"color: #0000ff;\"><strong>Managing Common and Local Users.<\/strong><\/span><\/li>\n<li><span style=\"color: #0000ff;\"><strong>Managing Local and Common Roles.<\/strong><\/span><\/li>\n<li><span style=\"color: #0000ff;\"><strong>Managing Local and Common Privileges.<\/strong><\/span><\/li>\n<li><span style=\"color: #0000ff;\"><strong>SYSASM \/ SYSBACKUP \/ SYSDG \/ SYSKM privileges.<\/strong><\/span><\/li>\n<\/ul>\n<p>You must\u00a0also be able to create very fast a new user via SQLPlus \/ SQL Developer \/ EM Interface.<\/p>\n<p><strong>Path to Documentation<\/strong>:<\/p>\n<p><span style=\"color: #800000;\">Oracle Database SQL Language Reference -&gt; CREATE USER \/ CREATE ROLE<\/span><br \/>\n<span style=\"color: #800000;\"> Oracle Database Administrator&#8217;s Guide -&gt; 7 Managing Users and Securing the Database<br \/>\n<\/span><\/p>\n<br>\r\nClick here to go back to the <a title=\"OCM 12c Preparation\" href=\"\/?page_id=2255\">Main OCM 12c Preparation<\/a> page.\r\n<br><br>\r\nHave you enjoyed? Please leave a comment or give a \ud83d\udc4d!\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-2632 jlk' href='javascript:void(0)' data-task='like' data-post_id='2632' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-2632 lc'>+1<\/span><\/a><\/div><\/div> <div class='status-2632 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Creating users, roles and give them privileges are one of the most basic thing a DBA must know. If you need to create any in the exam, you need to memorialize the syntax because this type of task is so basic that you can&#8217;t lose time on it. As in 12c we have now common &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\/\">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":[46],"tags":[],"class_list":["post-2632","post","type-post","status-publish","format-standard","hentry","category-ocm12c-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>OCM 12c Preparation - Create and manage users, roles, and privileges - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"Create and manage users, roles, and privileges for Oracle OCM 12c Certification\" \/>\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\/2017\/06\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\/\" \/>\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\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"OCM 12c Preparation &#8211; Create and manage users, roles, and privileges\",\"datePublished\":\"2017-06-07T12:00:22+00:00\",\"dateModified\":\"2017-06-07T12:06:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\\\/\"},\"wordCount\":167,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"OCM 12c Preparation\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\\\/\",\"name\":\"OCM 12c Preparation - Create and manage users, roles, and privileges - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"datePublished\":\"2017-06-07T12:00:22+00:00\",\"dateModified\":\"2017-06-07T12:06:12+00:00\",\"description\":\"Create and manage users, roles, and privileges for Oracle OCM 12c Certification\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OCM 12c Preparation - Create and manage users, roles, and privileges\"}]},{\"@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":"OCM 12c Preparation - Create and manage users, roles, and privileges - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Create and manage users, roles, and privileges for Oracle OCM 12c Certification","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\/2017\/06\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\/","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\/2017\/06\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"OCM 12c Preparation &#8211; Create and manage users, roles, and privileges","datePublished":"2017-06-07T12:00:22+00:00","dateModified":"2017-06-07T12:06:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\/"},"wordCount":167,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["OCM 12c Preparation"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\/","url":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\/","name":"OCM 12c Preparation - Create and manage users, roles, and privileges - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"datePublished":"2017-06-07T12:00:22+00:00","dateModified":"2017-06-07T12:06:12+00:00","description":"Create and manage users, roles, and privileges for Oracle OCM 12c Certification","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-and-manage-users-roles-and-privileges\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"OCM 12c Preparation - Create and manage users, roles, and privileges"}]},{"@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\/2632","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=2632"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/2632\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=2632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=2632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=2632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}