|Oracle9i OLAP User's Guide
Release 2 (9.2)
Part Number A95295-01
Administering Oracle OLAP, 6 of 9
To connect to the database, a user must present a user name and password that can be authenticated by database security. The privileges associated with that user name control the user's access to data. As a database administrator, you must set up user names with appropriate credentials for all users of Oracle OLAP applications.
To connect to the database using the OLAP API, users must have the following access rights to the database:
QUERY REWRITEsystem privilege
SELECTprivileges on the database objects containing the data to be analyzed
You can define user names and grant them these rights from the Security folder of Oracle Enterprise Manager.