Oracle User System Privileges Viewer
Displays system privileges granted to a specified user, including admin option status. Useful for security auditing and privilege verification.
oraclesqlsecurity-auditingv1.0.0
0 stars0 downloads12 views0 comments
By OracleDba • Created
Code
(18 lines)123456789101112131415161718
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/user_system_privs.sql
-- Author : Tim Hall
-- Description : Displays system privileges granted to a specified user.
-- Requirements : Access to the DBA views.
-- Call Syntax : @user_system_privs (user-name)
-- Last Modified: 27/07/2005
-- -----------------------------------------------------------------------------------
SET LINESIZE 200 VERIFY OFF
SELECT grantee,
privilege,
admin_option
FROM dba_sys_privs
WHERE grantee = UPPER('&1')
ORDER BY grantee, privilege;
SET VERIFY ON