D Oracle BI Discoverer Administrative Account Information

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.

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.