Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE 12c User Impersonation

Adam WickesOct 13 2019 — edited Oct 13 2019

Hi all,

Has anybody been able to get user impersonation working on 12c?
I have followed the doco in the following ticket and just end up with a blank screen when entering the impersonate URL (See below).

https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2327957_1.htm…

http://xxxxxxx:9502/analytics/saw.dll?Logon&NQUser=username&NQPassword=password123&Impersonate=impersonate_user

Nothing seems to happen in browser console or the logs.

We're also just using the built in SSO.

Any ideas?

Adam

This post has been answered by Adam Wickes on Oct 13 2019
Jump to Answer

Comments

CloudDB
YES

You can directly connect using jdbc thin method without install the oracle client in your local.

SQL Developer's default connection to the database is using the thin JDBC driver.
Defaulting to using the JDBC thin driver means there is no requirement for an Oracle
client install minimizing the configuration and footprint.

http://www.oracle.com/technetwork/developer-tools/sql-developer/what-is-sqldev-093866.html

Edited by: hitgon on Jan 2, 2013 5:36 PM
Reddy G
Thanks for ur replay..

can you tell me what information i need to provide for JDBC...in SQL developer I can see Custom JDBC URL option in Advanced part..
is there doc which will provide the step by step..
Jim Smith
Youdon't need to use the Advanced connection, Basic connection is sufficient.

You just need to provide a host, port number (probably 1521), and a SID or SERVICE. You can get these from the tnsnames file if you have one or from your DBA.
1 - 3