A Discoverer Administrative Account Information

This section lists Oracle Business Intelligence Discoverer administrative account information, and contains the following topics:

A.1 Database privileges granted by Oracle Business Intelligence Discoverer scripts to the PUBLIC user

The table below shows the database privileges granted by Oracle Business Intelligence Discoverer scripts to the PUBLIC user.

Script name(s) Script description Privileges granted
batchusr.sql Sets up the scheduling schema

(granted with INVOKER rights)

EXECUTE on EUL5_BATCH_REPOSITORY
demoddl.sql Sets up the Video Stores Tutorial data SELECT on all tables in VIDEO5 schema
eulsuqpp.sql Run QPP statistics on secure views SELECT on v_$session, v_$sesstat, v_$parameter, v_$sql, v_$open_cursor
eulgfn.sql, lineage.sql, eul5.sql Sets up PL/SQL packages EXECUTE on EUL5_GET_COMPLEX_FOLDER

EXECUTE on EUL5_GET_SIMPLE_FOLDER

EXECUTE on EUL5_GET_OBJECT

EXECUTE on EUL5_GET_ITEM

EXECUTE on EUL5_GET_HIERORD

EXECUTE on EUL5_GET_HIERLVL

EXECUTE on EUL5_GET_ADATE

EXECUTE on EUL5_GET_ANALYZED

EXECUTE on EUL5_GET_OBJECT_NAME

EXECUTE on EUL5_GET_ITEM_NAME

EXECUTE on EUL5_GET_APPS_USERRESP

EXECUTE on EUL5_GET_ISITAPPS_EUL

EXECUTE on EUL5_GET_LINURL


A.2 Database privileges granted by Oracle Business Intelligence Discoverer scripts to the Discoverer manager

The table below shows the database privileges granted by Oracle Business Intelligence Discoverer scripts to the Discoverer manager.

Package name(s) Package description Privileges granted
EUL5_DROP_BATCH_TABLE Grant execute to Discoverer managers. Batch repository package for dropping tables as part of batch user management.

(granted with GRANT rights)

With GRANT rights.