Granting Access Rights to Users

About access rights

To open a session in OLAP Services, a user must present a user name and password that can be authenticated in the database. The privileges associated with that user name control the user's access to data. A user who cannot present valid credentials cannot open a session. As a database administrator, you must set up user names with appropriate credentials for all users of OLAP Services applications.

Minimum rights

Users of OLAP applications must have the following access rights to the database:

• CONNECT role

• QUERY REWRITE system privilege

• CONNECT THROUGH OlapProxyUID proxy

• SELECT privileges on the database objects containing the data to be analyzed

You can define user names and grant them these rights through the Security node of Oracle Enterprise Manager. OlapProxyUID is an OLAP Services configuration setting. Its default value is OLAPSVR.