{"id":3317,"date":"2018-05-29T10:59:31","date_gmt":"2018-05-29T13:59:31","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=3317"},"modified":"2018-06-04T12:54:15","modified_gmt":"2018-06-04T15:54:15","slug":"como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/","title":{"rendered":"Como contornar a necessidade de WITH GRANT OPTION em views que acessam tabelas de outros usu\u00e1rios"},"content":{"rendered":"

H\u00e1 um bom tempo a Oracle introduziu limita\u00e7\u00f5es em VIEWS para evitar que algum usu\u00e1rio (com acesso \u00e0 um determinado objeto no banco de dados) repassasse seu conte\u00fado para outro, encapsulando-o em views.<\/p>\n

Como \u00e9 sempre melhor mostrar exemplos do que escrever teoria, digamos ent\u00e3o que temos 3 usu\u00e1rios no banco de dados ( USER_A, USER_B, USER_C <\/strong>).<\/p>\n

A tabela T1<\/strong> pertence ao USER_A<\/strong>.<\/p>\n

    \n
  1. USER_A<\/strong>: GRANT SELECT ON T1 to USER_B<\/strong> (sem GRANT OPTION)<\/li>\n
  2. USER_B<\/strong>: CREATE VIEW V1 AS SELECT * FROM USER_A.T1<\/li>\n
  3. USER_B<\/strong>: GRANT SELECT ON V1 TO USER_C<\/strong><\/li>\n
  4. USER_C<\/strong>: Executa um SELECT * FROM USER_B.V1<\/li>\n<\/ol>\n

    Vamos criar um demo e verificar o que acontece …<\/p>\n

    Criando usu\u00e1rios e permiss\u00f5es:<\/p>\n

    SQL> conn \/ as sysdba\r\nConnected.\r\nSQL> create user USER_A identified by oracle quota unlimited on usertbs;\r\n\r\nUser created.\r\n\r\nSQL> grant create session, create table to USER_A;\r\n\r\nGrant succeeded.\r\n\r\nSQL> create user USER_B identified by oracle;\r\n\r\nUser created.\r\n\r\nSQL> grant create session, create view to USER_B;\r\n\r\nGrant succeeded.\r\n\r\nSQL> create user USER_C identified by oracle;\r\n\r\nUser created.\r\n\r\nSQL> grant create session to USER_C;\r\n\r\nGrant succeeded.<\/pre>\n
    Criando objetos e concedendo os acessos..<\/p>\n
    SQL> conn USER_A\/oracle\r\nConnected.\r\nSQL> create table USER_A.t1 tablespace usertbs as select * from all_objects;\r\n\r\nTable created.\r\n\r\nSQL> select count(*) from USER_A.t1;\r\n\r\n  COUNT(*)\r\n----------\r\n     74052\r\n\r\nSQL> grant select on USER_A.t1 to USER_B;\r\n\r\nGrant succeeded.\r\n\r\nSQL> conn USER_B\/oracle\r\nConnected.\r\nSQL> create view USER_B.v1 as select * from USER_A.t1;\r\n\r\nView created.\r\n\r\nSQL> select count(*) from USER_B.v1;\r\n\r\n  COUNT(*)\r\n----------\r\n     74052\r\n\r\nSQL> grant select on USER_B.v1 to USER_C;\r\ngrant select on USER_B.v1 to USER_C\r\n                      *\r\nERROR at line 1:\r\nORA-01720: grant option does not exist for 'USER_A.T1'<\/pre>\n
    O erro ORA-01720<\/strong><\/span> aparece, exigindo que o USER_B<\/strong> tenha GRANT OPTION<\/em> na tabela T1<\/strong> do USER_A<\/strong> para que possa conceder grant em sua pr\u00f3pria view para o USER_C<\/strong>.<\/p>\n
    \"\"<\/p>\n
    Portanto, USER_C n\u00e3o ter\u00e1 acesso ao objeto USER_A. Justo! Faz parte da seguran\u00e7a que tanto precisamos.<\/p>\n
    Essa limita\u00e7\u00e3o j\u00e1 \u00e9 bem conhecida e documentada<\/a>:<\/p>\n
    NOTE:<\/p>\n
    To grant\u00a0SELECT\u00a0on a view to another user, either you must own all of the objects underlying the view or you must have been granted the\u00a0SELECT\u00a0object privilege\u00a0WITH\u00a0GRANT\u00a0OPTION\u00a0on all of those underlying objects. This is true even if the grantee already has\u00a0SELECT\u00a0privileges on those underlying objects<\/p><\/blockquote>\n
    No entanto, o que poucas pessoas sabem \u00e9 que essa prote\u00e7\u00e3o pode ser facilmente contornada usando algo chamado PIPELINED FUNCTIONS<\/strong>.<\/p>\n
    Como contornar ent\u00e3o a exig\u00eancia de GRANT OPTION?<\/h2>\n
    Se o usu\u00e1rio USER_B, propriet\u00e1rio da view, tamb\u00e9m tivesse o privil\u00e9gio CREATE PROCEDURE, ele poderia contornar o erro ORA-01720 encapsulando os resultados da tabela T1 em uma fun\u00e7\u00e3o com pipeline, e usar essa fun\u00e7\u00e3o dentro de sua view. Vamos ver como isso funcionaria:<\/p>\n
    Primeiro, vamos conceder CREATE PROCEDURE<\/em> para o USER_B:<\/p>\n
    SQL> conn \/ as sysdba\r\nConnected. \r\nSQL> grant create procedure to USER_B;\r\n\r\nGrant succeeded.<\/pre>\n
    Chegou a hora de criar a fun\u00e7\u00e3o com pipeline:<\/p>\n
    SQL> conn USER_B\/oracle\r\nConnected.\r\nSQL> CREATE OR REPLACE PACKAGE pkg_bypass_go AS\r\n  2  \r\n  3    TYPE t_tab IS TABLE OF USER_A.T1%ROWTYPE;\r\n  4  \r\n  5    FUNCTION run (p_sql  IN  CLOB)\r\n  6      RETURN t_tab PIPELINED;\r\n  7  \r\n  8  END pkg_bypass_go;\r\n  9  \/\r\n\r\nPackage created.\r\n\r\nSQL> CREATE OR REPLACE PACKAGE BODY pkg_bypass_go AS\r\n  2  \r\n  3    FUNCTION run (p_sql  IN  CLOB)\r\n  4      RETURN t_tab PIPELINED\r\n  5    IS\r\n  6      l_cursor SYS_REFCURSOR;\r\n  7      l_row    USER_A.T1%ROWTYPE;\r\n  8    BEGIN\r\n  9      OPEN l_cursor FOR p_sql;\r\n 10      LOOP\r\n 11        FETCH l_cursor\r\n 12        INTO  l_row;\r\n 13        EXIT WHEN l_cursor%NOTFOUND;\r\n 14        PIPE ROW (l_row);\r\n 15      END LOOP;\r\n 16      CLOSE l_cursor;\r\n 17      RETURN;\r\n 18    END run;\r\n 19  \r\n 20  END pkg_bypass_go;\r\n 21  \/\r\n\r\nPackage body created.<\/pre>\n
    E agora, criando a view e concedendo permiss\u00e3o de leitura ao USER_C:<\/p>\n
    SQL> conn USER_B\/oracle\r\nSQL> create or replace view USER_B.v1 as select * from table(pkg_bypass_go.run('select * from USER_A.t1'));\r\n\r\nView created.\r\n\r\nSQL> select count(*) from USER_B.v1;\r\n\r\n  COUNT(*)\r\n----------\r\n     74052\r\n\r\nSQL> grant select on USER_B.v1 to USER_C;\r\n\r\nGrant succeeded.\r\n\r\nSQL> conn USER_C\/oracle\r\nConnected.\r\nSQL> select count(*) from USER_B.v1;\r\n\r\n  COUNT(*)\r\n----------\r\n     74052\r\n<\/pre>\n
    Perfeito. O USER_B<\/strong> p\u00f4de dar acesso ao\u00a0USER_C<\/strong>na tabela do USER_A<\/strong> sem qualquer GRANT OPTION<\/em>.<\/p>\n
    A view est\u00e1 agora executando um select * from table(pkg_bypass_go.run(‘select * from USER_A.t1’))<\/em><\/strong><\/span>.<\/p>\n
    Observe que a tabela agora est\u00e1 sendo pr\u00e9-processada por uma fun\u00e7\u00e3o com pipeline para cada linha<\/strong><\/span>, por isso n\u00e3o espere nem de perto que o SELECT execute com a mesma performance que um acesso direto \u00e0 tabela. Portanto, use-o apenas para pequenas tabelas ou consultas que n\u00e3o precisem de desempenho m\u00e1ximo. Tamb\u00e9m recomendo melhorar o c\u00f3digo da PACKAGE, implementando alguns bulk collections e ajustes de pipeline, caso voc\u00ea precise melhorar o desempenho dessa abordagem.<\/p>\nGostou? N\u00e3o deixe de comentar ou deixar um \ud83d\udc4d!<\/b>\n
    Continue lendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,2],"tags":[],"class_list":["post-3317","post","type-post","status-publish","format-standard","hentry","category-security","category-database","item-wrap"],"yoast_head":"\nComo contornar a necessidade de WITH GRANT OPTION em views que acessam tabelas de outros usu\u00e1rios - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\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\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2018\\\/05\\\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2018\\\/05\\\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"Como contornar a necessidade de WITH GRANT OPTION em views que acessam tabelas de outros usu\u00e1rios\",\"datePublished\":\"2018-05-29T13:59:31+00:00\",\"dateModified\":\"2018-06-04T15:54:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2018\\\/05\\\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\\\/\"},\"wordCount\":496,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2018\\\/05\\\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/img_5b0c55bda890c.png\",\"articleSection\":[\"Database Security\",\"Oracle Database General\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2018\\\/05\\\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2018\\\/05\\\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2018\\\/05\\\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\\\/\",\"name\":\"Como contornar a necessidade de WITH GRANT OPTION em views que acessam tabelas de outros usu\u00e1rios - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2018\\\/05\\\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2018\\\/05\\\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/img_5b0c55bda890c.png\",\"datePublished\":\"2018-05-29T13:59:31+00:00\",\"dateModified\":\"2018-06-04T15:54:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2018\\\/05\\\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2018\\\/05\\\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2018\\\/05\\\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/img_5b0c55bda890c.png\",\"contentUrl\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/img_5b0c55bda890c.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2018\\\/05\\\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como contornar a necessidade de WITH GRANT OPTION em views que acessam tabelas de outros usu\u00e1rios\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@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":"Como contornar a necessidade de WITH GRANT OPTION em views que acessam tabelas de outros usu\u00e1rios - DBA - Rodrigo Jorge - Oracle Tips and Guides","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\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/","twitter_misc":{"Escrito por":"DBA RJ","Est. tempo de leitura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"Como contornar a necessidade de WITH GRANT OPTION em views que acessam tabelas de outros usu\u00e1rios","datePublished":"2018-05-29T13:59:31+00:00","dateModified":"2018-06-04T15:54:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/"},"wordCount":496,"commentCount":3,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"image":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/#primaryimage"},"thumbnailUrl":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2018\/05\/img_5b0c55bda890c.png","articleSection":["Database Security","Oracle Database General"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/","url":"https:\/\/www.dbarj.com.br\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/","name":"Como contornar a necessidade de WITH GRANT OPTION em views que acessam tabelas de outros usu\u00e1rios - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/#primaryimage"},"image":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/#primaryimage"},"thumbnailUrl":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2018\/05\/img_5b0c55bda890c.png","datePublished":"2018-05-29T13:59:31+00:00","dateModified":"2018-06-04T15:54:15+00:00","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/#primaryimage","url":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2018\/05\/img_5b0c55bda890c.png","contentUrl":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2018\/05\/img_5b0c55bda890c.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2018\/05\/como-contornar-a-necessidade-de-with-grant-option-em-views-que-acessam-tabelas-de-outros-usuarios\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/pt-br\/"},{"@type":"ListItem","position":2,"name":"Como contornar a necessidade de WITH GRANT OPTION em views que acessam tabelas de outros usu\u00e1rios"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/pt-br\/#website","url":"https:\/\/www.dbarj.com.br\/pt-br\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/pt-br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"pt-BR","@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\/pt-br\/wp-json\/wp\/v2\/posts\/3317","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/comments?post=3317"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts\/3317\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/media?parent=3317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/categories?post=3317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/tags?post=3317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}