Skip to the content.

DIS Access Privileges – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Discoverer · all Discoverer reports

Overview

Discoverer access privileges

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Access Type, Access Count within x Days, Show Active Objects only, Show Active Users/Roles only, End User Layer

Oracle EBS Tables Used

eul5_access_privs, eul5_documents, eul5_bas, eul5_qpp_stats, eul5_ba_obj_links, fnd_user_resp_groups

Report Categories

Enginatics

DIS Business Areas, DIS Workbooks, Folders, Items and LOVs, DIS Worksheet Execution History, DIS Converter Diagnostic Dump, DIS Workbook Export Script, DIS Folders, Business Areas, Items and LOVs, DIS Workbook Import Validation, DIS Workbook Conversion Selection, DIS Worksheet SQLs

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output DIS Access Privileges 04-Jan-2019 134602.xlsx
Blitz Report™ XML Import DIS_Access_Privileges.xml
SQL Source DIS Access Privileges.sql
Full Report on Enginatics www.enginatics.com/reports/dis-access-privileges/

Case Study & Technical Analysis

Abstract

The DIS Access Privileges report is a security auditing tool for Oracle Discoverer. It maps the complex web of permissions within the End User Layer (EUL), showing which users or responsibilities have access to specific Business Areas and Workbooks. This report is essential for compliance audits and for cleaning up access rights during a migration project.

Technical Analysis

Core Relationships

Key Tables

Operational Use Cases


© Enginatics GmbH