DBA Object Access Privileges – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Database object privileges for a specific user, including privileges inherited through role grants. Useful for DB access security audits to understand exactly what objects a user can access and how the access was granted (directly or through which role chain).

Report Parameters

Grantee, Privilege Type, Object Owner, Object Type, Privilege

Oracle EBS Tables Used

dual, dba_role_privs, dba_tab_privs, dba_sys_privs

Report Categories

Enginatics

DBA ORDS Configuration Validation, DBA Blitz Report ORDS Configuration, DBA SGA Active Session History, DBA SGA Blocking Session Summary, DBA AWR Blocking Session Summary, DBA AWR Active Session History, DIS Access Privileges, DBA Table Modifications, Blitz Report VPD Policy Setup

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output DBA Object Access Privileges 10-Apr-2026 092105.xlsx
Blitz Report™ XML Import DBA_Object_Access_Privileges.xml
Full SQL on Enginatics www.enginatics.com/reports/dba-object-access-privileges/

© 2026 Enginatics