OBIEE 11g: Impersonation

Impersonation is probably the best way to troubleshoot production issues.  Below are the things that needs to be done in order for an Aministrator to be able to impersonate as any user from the system:

1) Application policies for BI Administrator role needs to be modified around to add two new permissions:
 a) oracle.bi.server.impersonateUser 
 b) oracle.bi.server.queryUserPopulation


 

 2) The privileges under manage privileges in Administration menu should be given to BIAdministrator/Presentation Server Administrator role.







After making the above changes, the syntax for the URL is:


https://localhost:7001/analytics/saw.dll?Logon&NQUser=AdministratorUsername&NQPassword=AdministratorPassword&Impersonate=Usernameofthepersonthatyouaretryingtoimpersonate


Until Next Post.. :)