Setting Up User Names

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:

• CONNECT role
• QUERY REWRITE system privilege
• SELECT privileges 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.