how to bypass login screen for few users
700663Aug 21 2009 — edited Aug 24 2009Hi Everyone,
I have a requirement where for few senior executives, have to show the reports directly without prompting for id/password.
I am able to achieve the purpose by passing a common id/password (NQuser, NQpassword) in the URL given to the set of users to access the particular report. But this way the id/pwd would be exposed.
eg: http://ip/analytics/saw.dll?Dashboard&nquser=Administrator&nqpassword=Administrator&report path
We already have the authentication in place as below:
SELECT ':USER' FROM security_table WHERE LOGIN =Upper( ':USER') AND PASSWORD=':PASSWORD'
Have seen the below two posts on bypassing the login screen but cannot use these approaches:
http://tipsonobiee.blogspot.com/2009/07/bypass-obiee-log-on-screen.html -> This will bypass the screen for all probably.
http://oraclebizint.wordpress.com/2008/06/30/oracle-bi-ee-1013332-public-reports-and-dashboards-bypassing-authentication/ -> Authentication is already there from external table so cannot use it.
Is there any approach other than SSO or GO URL to implement it.
Thanks in advance.