OBIEE - How to define one different database credential for each user (the shared logon) ?
Table of Contents
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
2 - Articles Related
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 Oracle BI Administration tool
- 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 :
