{"id":750,"date":"2019-03-12T17:23:34","date_gmt":"2019-03-12T20:23:34","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=750"},"modified":"2019-03-12T17:23:34","modified_gmt":"2019-03-12T20:23:34","slug":"select-obter-todas-as-permissoes-do-owner-e-conceder-a-um-usuario-2","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2019\/03\/12\/select-obter-todas-as-permissoes-do-owner-e-conceder-a-um-usuario-2\/","title":{"rendered":"Oracle SELECT, OBTER TODAS AS PERMISSOES SELECT DO OWNER E CONCEDER A UM USUARIO"},"content":{"rendered":"<p>Obtendo todas as permiss\u00f5es SELECT do Owner e conceder a um usu\u00e1rio.<\/p>\n<pre class=\"lang:plsql decode:true \">SYS@ORCL &gt; select 'GRANT SELECT ON '|| owner ||'.' || object_name || ' TO USER;' from all_objects where owner='NOME';\n\nGRANT SELECT ON NBS.PK_BKP_OPER_ID TO USER;\nGRANT SELECT ON NBS.SEQ_BKP_OPER_ID TO USER;\nGRANT SELECT ON NBS.BKP_TABELA TO USER;\nGRANT SELECT ON NBS.PK_BKP_TABELA_ID TO USER;\nGRANT SELECT ON NBS.SEQ_BKP_TABELA_ID TO USER;\nGRANT SELECT ON NBS.BKP_CAMPO_BLOB TO USER;\nGRANT SELECT ON NBS.PK_BKP_CAMPO_BLOB_ID TO USER;\nGRANT SELECT ON NBS.SEQ_BKP_CAMPO_BLOB_ID TO USER;\nGRANT SELECT ON NBS.BKP_MOVIMENTO TO USER;\nGRANT SELECT ON NBS.PK_BKP_MOV_ID TO USER;\nGRANT SELECT ON NBS.SEQ_BKP_MOV_ID TO USER;\nGRANT SELECT ON NBS.HYUNDAI_WS_LOG TO USER;\nGRANT SELECT ON NBS.SYS_C00101260 TO USER;\nGRANT SELECT ON NBS.SEQ_HYUNDAI_WS_LOG TO USER;\nGRANT SELECT ON NBS.IDXCONTROLE_SERIE TO USER;\nGRANT SELECT ON NBS.IDX_SPED_ITENS_DOCUMENTO_DATA TO USER;\nGRANT SELECT ON NBS.FORD_EXT_MOV_OIC TO USER;\nGRANT SELECT ON NBS.IDX_FORD_EXT_MOV_OIC TO USER;\n\n13786 rows selected.\n<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Obtendo todas as permiss\u00f5es SELECT do Owner e conceder a um usu\u00e1rio. SYS@ORCL &gt; select &#8216;GRANT SELECT ON &#8216;|| owner ||&#8217;.&#8217; || object_name || &#8216; TO USER;&#8217; from all_objects where owner=&#8217;NOME&#8217;; GRANT SELECT ON NBS.PK_BKP_OPER_ID TO USER; GRANT SELECT ON NBS.SEQ_BKP_OPER_ID TO USER; GRANT SELECT ON NBS.BKP_TABELA TO USER; GRANT SELECT ON NBS.PK_BKP_TABELA_ID TO USER;&#8230;<\/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":[36,147,206,324,325],"class_list":["post-750","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-all_objects-where-owner","tag-grant-select","tag-obter-todas-as-permissoes-do-owner-e-conceder-a-um-usuario","tag-select","tag-select-grant-select-on-owner-object_name-to-user-from-all_objects-where-ownernome"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/750","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=750"}],"version-history":[{"count":1,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/750\/revisions"}],"predecessor-version":[{"id":1644,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/750\/revisions\/1644"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=750"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}