OBIEE 11g: How To Connect to a Secure Oracle Database with User Specific Connection Pool Credentials

(Doc ID 1632879.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.140114 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.140114 and later
IBM AIX on POWER Systems (64-bit)

Goal

You need to connect to a secure (Oracle) database through OBIEE 11g.

The administrator of OBIEE is not the same as the administrator of the secure database. You want OBIEE users to see secure data, but you do not want the OBIEE administrator to see data from the secure database.

If you use a shared pool, the OBIEE administrator can see data in the Administration Tool (for example, accessing the database through the physical layer).

If you base security via roles, the OBIEE administrator could give himself the required role.

However, with specific credentials, OBIEE users that are allowed to see data have their own log on credentials and the data filtering is done by the secure database depending on the connection user (database user).

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms