top of page

PRIVILEGIOS

Ver los privilegios asignados a un objeto

Ver lo privilegios de un usuario de la BDs.

select grantee, owner, table_name AS OBJECT_NAME, grantor, privilege
from dba_tab_privs
where table_name in ('NOMBRE_DEL_OBJETO');

select * from DBA_ROLE_PRIVS where 
grantee = 'USERNAME';

bottom of page