Oracle® Fusion Middleware Configuration Guide for Oracle Business Intelligence Discoverer 11g Release 1 (11.1.1) B40107-04 |
|
![]() Previous |
![]() Next |
This appendix lists Discoverer administrative account information, and contains the following topics:
Section D.1, "Database privileges granted by Oracle BI Discoverer scripts to the PUBLIC user"
Section D.2, "Database privileges granted by Oracle BI Discoverer scripts to the Discoverer manager"
Note: For information about Discoverer accounts and schemas, see Oracle Fusion Middleware Administrator's Guide.
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 |
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. |