Oracle® Business Intelligence Discoverer Configuration Guide
10g Release 2 (10.1.2.1) for Microsoft Windows and Solaris Operating System (SPARC) B13918-03 |
|
Previous |
Next |
This section lists Discoverer administrative account information, and contains the following topics:
Section C.1, "Database privileges granted by OracleBI Discoverer scripts to the PUBLIC user"
Section C.2, "Database privileges granted by OracleBI Discoverer scripts to the Discoverer manager"
Note: For information about Discoverer accounts and schemas, see Oracle Application Server Administrator's Guide.
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 |
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. |