Oracle® Business Intelligence Discoverer Administration Guide
10g Release 2 (10.1.2.1) B13916-04 |
|
Previous |
Next |
This section lists Oracle Business Intelligence Discoverer administrative account information, and contains the following topics:
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 |
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. |