{"id":245,"date":"2018-06-04T17:27:17","date_gmt":"2018-06-04T20:27:17","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=245"},"modified":"2018-06-04T17:27:17","modified_gmt":"2018-06-04T20:27:17","slug":"verificando-permissoes-e-grants-de-usuarios","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2018\/06\/04\/verificando-permissoes-e-grants-de-usuarios\/","title":{"rendered":"Verificando permiss\u00f5es e GRANTS de usu\u00e1rios"},"content":{"rendered":"<p>Verificando permiss\u00f5es do usu\u00e1rio TESTE_ORCL<\/p>\n<pre class=\"lang:plsql decode:true\">SYS@ORCL &gt; SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE LIKE 'TESTE_ORCL';\n\nGRANTEE                        PRIVILEGE                                ADM\n------------------------------ ---------------------------------------- ---\nTESTE_ORCL                      ALTER SESSION                            NO\nTESTE_ORCL                      ALTER SYSTEM                             NO\nTESTE_ORCL                      CREATE SEQUENCE                          NO\nTESTE_ORCL                      CREATE TABLE                             NO\nTESTE_ORCL                      MANAGE TABLESPACE                        NO\nTESTE_ORCL                      EXECUTE ANY PROCEDURE                    NO\nTESTE_ORCL                      CREATE TRIGGER                           NO\nTESTE_ORCL                      CREATE VIEW                              NO\nTESTE_ORCL                      SELECT ANY TABLE                         NO\nTESTE_ORCL                      UNLIMITED TABLESPACE                     NO\nTESTE_ORCL                      CREATE SESSION                           NO\nTESTE_ORCL                      SELECT ANY DICTIONARY                    NO\nTESTE_ORCL                      CREATE PROCEDURE                         NO\n\n13 rows selected.<\/pre>\n<p>ou<\/p>\n<pre class=\"lang:plsql decode:true\">SYS@ORCL &gt; select * from (\nselect 'GRANT '||privilege||' TO '||grantee||';' from dba_sys_privs\nwhere grantee in ('TESTE_ORCL')\nunion all\nselect 'grant '||privilege||' on '||grantor||'.'||table_name||' to '||grantee||';' from dba_tab_privs\nwhere grantee in ('TESTE_ORCL')\nunion all\nselect 'GRANT '||GRANTED_ROLE||' TO '||grantee||';' from dba_role_privs\n  9  where grantee in ('TESTE_ORCL'));\n----------------------------------------------------------------------\nGRANT ALTER SESSION TO TESTE_ORCL;\nGRANT ALTER SYSTEM TO TESTE_ORCL;\nGRANT CREATE SEQUENCE TO TESTE_ORCL;\nGRANT CREATE TABLE TO TESTE_ORCL;\nGRANT MANAGE TABLESPACE TO TESTE_ORCL;\nGRANT EXECUTE ANY PROCEDURE TO TESTE_ORCL;\nGRANT CREATE TRIGGER TO TESTE_ORCL;\nGRANT CREATE VIEW TO TESTE_ORCL;\nGRANT SELECT ANY TABLE TO TESTE_ORCL;\nGRANT UNLIMITED TABLESPACE TO TESTE_ORCL;\nGRANT CREATE SESSION TO TESTE_ORCL;\nGRANT SELECT ANY DICTIONARY TO TESTE_ORCL;\nGRANT CREATE PROCEDURE TO TESTE_ORCL;\nGRANT CONNECT TO TESTE_ORCL;\n\n14 rows selected.\n<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Verificando permiss\u00f5es do usu\u00e1rio TESTE_ORCL SYS@ORCL &gt; SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE LIKE &#8216;TESTE_ORCL&#8217;; GRANTEE PRIVILEGE ADM &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- &#8212; TESTE_ORCL ALTER SESSION NO TESTE_ORCL ALTER SYSTEM NO TESTE_ORCL CREATE SEQUENCE NO TESTE_ORCL CREATE TABLE NO TESTE_ORCL MANAGE TABLESPACE NO TESTE_ORCL EXECUTE ANY PROCEDURE NO TESTE_ORCL CREATE TRIGGER NO TESTE_ORCL CREATE VIEW NO TESTE_ORCL&#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":[],"class_list":["post-245","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/245","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=245"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/245\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}