Skip Headers
Oracle® Business Intelligence Discoverer Configuration Guide
10g Release 2 (10.1.2.1) for Microsoft Windows and Solaris Operating System (SPARC)
B13918-03
  Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
Next
Next
 

C OracleBI Discoverer administrative account information

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

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

C.1 Database privileges granted by OracleBI Discoverer scripts to the PUBLIC user

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


C.2 Database privileges granted by OracleBI Discoverer scripts to the Discoverer manager

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