Skip to content

README.md

Latest commit

 

History

History
75 lines (54 loc) · 5.3 KB

README.md

File metadata and controls

75 lines (54 loc) · 5.3 KB
layout default
title DIS Access Privileges | Oracle EBS SQL Report
description Discoverer access privileges – Oracle E-Business Suite SQL report
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, DIS, Access, Privileges, eul5_access_privs, eul5_documents, eul5_bas
permalink /DIS%20Access%20Privileges/

DIS Access Privileges – Oracle EBS SQL Report

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

Overview

Discoverer access privileges

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, table, eul5_ba_obj_links, fnd_user_resp_groups

Report Categories

Enginatics

Related Reports

DIS Business Areas, DIS Workbooks, Folders, Items and LOVs, DIS Worksheet Execution History, DIS Folders, Business Areas, Items and LOVs, DIS Workbook Import Validation, DIS Workbook Export Script, DIS Worksheet SQLs, DIS Users, DIS Discoverer and Blitz Report Users

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 DIS Access Privileges 04-Jan-2019 134602.xlsx
Blitz Report™ XML Import DIS_Access_Privileges.xml
Full SQL 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

  • Users/Roles: Discoverer privileges can be granted to individual Oracle Users or to Responsibilities (Roles).
  • Business Areas: The primary container for data access. If a user has access to a Business Area, they can query any folder within it.
  • Workbooks: Specific reports shared with users.

Key Tables

  • EUL5_ACCESS_PRIVS: The central table linking users/roles (AP_EU_ID) to objects (AP_ELEMENT_ID).
  • EUL5_DOCUMENTS: Stores workbook definitions.
  • EUL5_BAS: Stores Business Area definitions.

Operational Use Cases

  • Security Audit: "Who has access to the 'HR Confidential' Business Area?"
  • License Management: Identifying inactive users who still hold Discoverer privileges.
  • Migration Planning: Determining which users need to be trained on the new reporting tool based on their current access.

Useful Links

© 2026 Enginatics