Oracle: Verificar permissões (grants) de um usuário

Posted by Bento | Posted in Banco de Dados, Oracle, PL/SQL | Posted on 06-08-2014-05-2008

0

SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE LIKE ‘FABIANO’

 

permissao_oracle_DBA_SYS_PRIVS

SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE LIKE ‘FABIANO’

SELECT GRANTEE, GRANTED_ROLE, ADMIN_OPTION, DEFAULT_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE LIKE ‘FABIANO’

 

permissao_oracle_DBA_ROLE_PRIVS

Write a comment