Listar privilegios de un usuario en Oracle

Categorías:

Para ver los permisos o privilegios que un usuario en nuestra base de datos Oracle, ejecutamos el siguiente SQL

 

set pages 200; 
set lines 200;
col GRANTEE format a20;	     
col OWNER format a10;	     
col TABLE_NAME 	format a35;		 
col GRANTOR	 format a10;
col PRIVILEGE format a10;
select * from dba_tab_privs  where grantee = 'SQAREPO' or grantee in (select granted_role from dba_role_privs connect by prior granted_role = grantee start with grantee = 'SQAREPO') order by 1,2,3,4;

Cuya salida será entonces algo parecido a esto…..

APP_DEVELOPER_ROLE   ICEMNGR	VTE_VENTA_ESP_FINAL		    ICEMNGR    UPDATE	  NO  NO  NO  TABLE
APP_DEVELOPER_ROLE   ICEMNGR	VTE_VENTA_ESP_FINAL		    ICEMNGR    DELETE	  NO  NO  NO  TABLE
APP_DEVELOPER_ROLE   ICEMNGR	VTE_VENTA_ESP_FINAL_VEF_CODIGO	    ICEMNGR    SELECT	  NO  NO  NO  SEQUENCE
APP_DEVELOPER_ROLE   ICEMNGR	V_JERARQUIA_GRUPOS_PED		    ICEMNGR    SELECT	  NO  NO  NO  VIEW
APP_DEVELOPER_ROLE   ICEMNGR	V_JERARQUIA_GRUPOS_PED		    ICEMNGR    INSERT	  NO  NO  NO  VIEW
APP_DEVELOPER_ROLE   ICEMNGR	V_JERARQUIA_GRUPOS_PED		    ICEMNGR    UPDATE	  NO  NO  NO  VIEW
APP_DEVELOPER_ROLE   ICEMNGR	V_JERARQUIA_GRUPOS_PED		    ICEMNGR    DELETE	  NO  NO  NO  VIEW
SQAREPO 	     ICEMNGR	RPODIFPRC			    ICEMNGR    INSERT	  NO  NO  NO  TABLE
SQAREPO 	     ICEMNGR	RPODIFPRC			    ICEMNGR    SELECT	  NO  NO  NO  TABLE
SQAREPO 	     ICEMNGR	RPODIFPRC			    ICEMNGR    UPDATE	  NO  NO  NO  TABLE
SQAREPO 	     ICEMNGR	RPODIFPRC			    ICEMNGR    DELETE	  NO  NO  NO  TABLE
SQAREPO 	     ICEMNGR	VTE_MOTIVO_SUCURS		    ICEMNGR    INSERT	  NO  NO  NO  TABLE

 

 

Sin respuestas

Deja un comentario