Oracle Database Roles Report
Displays a list of all roles defined in the Oracle database along with their authentication details. Useful for reviewing role configuration and auditing security setup.
oraclesqlsecurity-auditingv1.0.0
0 stars0 downloads13 views0 comments
By OracleDba • Created
Code
(20 lines)1234567891011121314151617181920
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/roles.sql
-- Author : Tim Hall
-- Description : Displays a list of all roles and privileges granted to the specified user.
-- Requirements : Access to the USER views.
-- Call Syntax : @roles
-- Last Modified: 27/02/2018
-- -----------------------------------------------------------------------------------
SET SERVEROUTPUT ON
SET VERIFY OFF
COLUMN role FORMAT A30
SELECT a.role,
a.password_required,
a.authentication_type
FROM dba_roles a
ORDER BY a.role;
SET VERIFY ON