Skip Headers

Oracle® Business Intelligence Discoverer Administration Guide 10g Release 2 (10.1.2.1) B13916-04 |
| Library | Product | Contents | Index

Previous | Next |

# A Oracle Business Intelligence Discoverer administrative account information

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

- Database privileges granted by Oracle Business Intelligence Discoverer scripts to the PUBLIC user

- Database privileges granted by Oracle Business Intelligence Discoverer scripts to the Discoverer manager

## Database privileges granted by Oracle Business Intelligence Discoverer scripts to the PUBLIC user

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

## Database privileges granted by Oracle Business Intelligence Discoverer scripts to the Discoverer manager

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.