OBIEE - How to define one different database credential for each user (the shared logon) ?

1 - About

For system architecture reasons, you may want to have one database credential by user.

Example :

  • When one schema (of one user) is the logical entity of one company, you may decide to have the same table in two different schema but with the data for only one company

3 - How to do

To achieve it, you have to unmark the check box “Shared Logon” of the connection pool property in the physical layer. You can remark that the user and password box become gray.

Now, the Obiee users don't share no the same credential and you have to define for each Obiee user, one credential (one username, one password).

To define the new credentials :

  • open the security manager (Manage> Security)
  • click on the user map
  • double click on a user
  • define in the tab logon the user credential for your database

3.1 - The importance of disabling the cache

If the user don't share the same data, you have to disable the query cache by setting NO on the dat:obiee:bi_server:cache:obiee_bi_server_application_cache_parameters parameter in the cache section of the file dat:obiee:bi_server:nqsconfig

If you don't disable the query cache, Obiee will perform an hit cache and retrieve the data from its cache as you can see in the log :

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap