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

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

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

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 :