OBIEE 11g: How To Connect to a Secure Oracle Database with User Specific Connection Pool Credentials
Last updated on FEBRUARY 01, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.140114 and later
Business Intelligence Server Enterprise Edition - Version 126.96.36.199.140114 and later
IBM AIX on POWER Systems (64-bit)
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).
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