Verificando permissões do usuário TESTE_ORCL
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
SYS@ORCL > SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE LIKE 'TESTE_ORCL'; GRANTEE PRIVILEGE ADM ------------------------------ ---------------------------------------- --- 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 SELECT ANY TABLE NO TESTE_ORCL UNLIMITED TABLESPACE NO TESTE_ORCL CREATE SESSION NO TESTE_ORCL SELECT ANY DICTIONARY NO TESTE_ORCL CREATE PROCEDURE NO 13 rows selected. |
ou
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
SYS@ORCL > select * from ( select 'GRANT '||privilege||' TO '||grantee||';' from dba_sys_privs where grantee in ('TESTE_ORCL') union all select 'grant '||privilege||' on '||grantor||'.'||table_name||' to '||grantee||';' from dba_tab_privs where grantee in ('TESTE_ORCL') union all select 'GRANT '||GRANTED_ROLE||' TO '||grantee||';' from dba_role_privs 9 where grantee in ('TESTE_ORCL')); ---------------------------------------------------------------------- GRANT ALTER SESSION TO TESTE_ORCL; GRANT ALTER SYSTEM TO TESTE_ORCL; GRANT CREATE SEQUENCE TO TESTE_ORCL; GRANT CREATE TABLE TO TESTE_ORCL; GRANT MANAGE TABLESPACE TO TESTE_ORCL; GRANT EXECUTE ANY PROCEDURE TO TESTE_ORCL; GRANT CREATE TRIGGER TO TESTE_ORCL; GRANT CREATE VIEW TO TESTE_ORCL; GRANT SELECT ANY TABLE TO TESTE_ORCL; GRANT UNLIMITED TABLESPACE TO TESTE_ORCL; GRANT CREATE SESSION TO TESTE_ORCL; GRANT SELECT ANY DICTIONARY TO TESTE_ORCL; GRANT CREATE PROCEDURE TO TESTE_ORCL; GRANT CONNECT TO TESTE_ORCL; 14 rows selected. |