Unlocking Database Identities

OLAP Services identities

To communicate with the database, OLAP Services must authenticate itself as a user. OLAP Services uses two identities, which are set up automatically by the installation process.

Database User Name	Default Password	Description	OLAP Services Configuration Parameters
OLAPSVR	INSTANCE	Proxy user	OlapProxyUID OlapProxyPwd
OLAPDBA	OLAPDBA	DBA user	UserID UserPassword

These user names and passwords are identified in two places: the database and the OLAP repository. When the OLAP service needs to authenticate itself with the database, it uses the credentials that it finds in the repository. If they match the appropriately configured credentials for a user in the database, then the OLAP service has the privileges it needs. It is therefore vital that the credentials in the OLAP repository match those in the database.

Important: This correspondence between an identity stored in the local repository and an identity defined in the database occurs automatically upon installation. However, you must unlock these identities in the database and change their passwords in both locations before OLAP Services can be used. Users will not be able to connect using the OLAP API until you have completed this step.

The proxy and DBA identities are defined in the database with different privileges and are used for different tasks by OLAP Services. They are not intended for use by client sessions.

Procedure: Changing the proxy and DBA passwords

Follow these steps to change the passwords associated with the proxy and DBA identities used by OLAP Services:

1. Open Oracle Enterprise Manager and connect to your database.

2. Expand the Security node in the navigator tree.

3. Under Users, select the OLAPSVR user to change the proxy password.

   or

   Select the OLAPDBA user to change the DBA password.

4. Change the password on the General page.

5. Choose Apply.

6. Open Instance Manager by right-clicking on the OLAP node.

7. To change the OLAPSVR password, select Security under the Parameters node. Then change the password on the General page.

   or

   To change the OLAPDBA password, select DBA under the Security node. Then change the UserPassword on the General page.

8. Choose Apply.

9. Stop and restart the instance of OLAP Services, following the instructions in "Stopping or Pausing OLAP Services" and "Starting OLAP Services".

Figure: Proxy user parameters

The following figure shows the OlapProxyUID and OlapProxyPwd settings on the Security sheet.

Figure: DBA user parameters

The following figure shows the DBA user settings on the DBA sheet.