{"id":998,"date":"2020-04-11T17:18:32","date_gmt":"2020-04-11T20:18:32","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=998"},"modified":"2020-04-11T17:18:32","modified_gmt":"2020-04-11T20:18:32","slug":"extrair-ddl-roles","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2020\/04\/11\/extrair-ddl-roles\/","title":{"rendered":"Extrair DDL roles"},"content":{"rendered":"<p>Extrair DDL ROLES<\/p>\n<pre class=\"lang:sh decode:true  \">set heading off;\nset echo off;\nset pages 1000\nset long 3000\nspool extrair_roles_ddl.sql\nselect dbms_metadata.get_ddl('ROLE', ROLE) from dba_roles;\nspool off\n\n\n\nCREATE ROLE \"CONNECT\";\n\nCREATE ROLE \"RESOURCE\";\n\nCREATE ROLE \"DBA\";\n\nCREATE ROLE \"PDB_DBA\";\n\nCREATE ROLE \"AUDIT_ADMIN\";\n\nCREATE ROLE \"AUDIT_VIEWER\";\n\nCREATE ROLE \"SELECT_CATALOG_ROLE\";\n<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Extrair DDL ROLES set heading off; set echo off; set pages 1000 set long 3000 spool extrair_roles_ddl.sql select dbms_metadata.get_ddl(&#8216;ROLE&#8217;, ROLE) from dba_roles; spool off CREATE ROLE &#8220;CONNECT&#8221;; CREATE ROLE &#8220;RESOURCE&#8221;; CREATE ROLE &#8220;DBA&#8221;; CREATE ROLE &#8220;PDB_DBA&#8221;; CREATE ROLE &#8220;AUDIT_ADMIN&#8221;; CREATE ROLE &#8220;AUDIT_VIEWER&#8221;; CREATE ROLE &#8220;SELECT_CATALOG_ROLE&#8221;; &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[87,95,141,317],"class_list":["post-998","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-dba_roles","tag-dbms_metadata-get_ddl","tag-extrair-ddl-de-roles","tag-roles"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/998","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=998"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/998\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}