Skip Headers
Oracle® Fusion Middleware Configuration Guide for Oracle Business Intelligence Discoverer
11g Release 1 (11.1.1)

Part Number B40107-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

D Oracle BI Discoverer Administrative Account Information

This appendix lists Discoverer administrative account information, and contains the following topics:

Note: For information about Discoverer accounts and schemas, see Oracle Fusion Middleware Administrator's Guide.

D.1 Database privileges granted by Oracle BI Discoverer scripts to the PUBLIC user

The table below shows the database privileges granted by Oracle BI 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


D.2 Database privileges granted by Oracle BI Discoverer scripts to the Discoverer manager

The table below shows the database privileges granted by Oracle BI Discoverer scripts to EUL owners.

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.