Oracle Proxy Users Report
Displays proxy user relationships in the Oracle database, showing which users are allowed to connect on behalf of others. Useful for auditing proxy authentication configurations and delegated access setups.
oraclesqlsecurity-auditingv1.0.0
0 stars0 downloads12 views0 comments
By OracleDba • Created
Code
(20 lines)1234567891011121314151617181920
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/proxy_users.sql
-- Author : Tim Hall
-- Description : Displays information about proxy users.
-- Requirements : Access to the PROXY_USERS views.
-- Call Syntax : @proxy_users.sql {username or %}
-- Last Modified: 02/06/2020
-- -----------------------------------------------------------------------------------
SET VERIFY OFF
COLUMN proxy FORMAT A30
COLUMN client FORMAT A30
SELECT proxy,
client,
authentication,
flags
FROM proxy_users
WHERE proxy LIKE UPPER('%&1%');