Hi All

We had configured SSO using HTTPD and Shibboleth in OBIEE 11.1.1.9 and used the REMOTE_USER Variable in http header to login to the application.

But i see currently this is not working in OBIEE 12c.I am getting the below Error Messages

Caused by: javax.security.auth.login.LoginException: javax.security.auth.login.FailedLoginException: [Security:090938]Authentication failure: The specified user failed to log in. javax.security.auth.login.FailedLoginException: [Security:090302]Authentication Failed: User specified user denied

  at oracle.security.jps.internal.jaas.module.assertion.JpsUserAssertionLoginModule.login(JpsUserAssertionLoginModule.java:154)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:498)

  at javax.security.auth.login.LoginContext.invoke(LoginContext.java:755)

  at javax.security.auth.login.LoginContext.access$000(LoginContext.java:195)

  at javax.security.auth.login.LoginContext$4.run(LoginContext.java:682)

  at javax.security.auth.login.LoginContext$4.run(LoginContext.java:680)

  at java.security.AccessController.doPrivileged(Native Method)

  at javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:680)

  at javax.security.auth.login.LoginContext.login(LoginContext.java:587)

  at oracle.bi.security.subject.SubjectAsserter.assertUser(SubjectAsserter.java:95)

  at oracle.bi.security.centaurus.AssertUserAction.execute(AssertUserAction.java:44)

  ... 61 more

Caused by: oracle.security.jps.internal.api.jaas.AssertionException: javax.security.auth.login.FailedLoginException: [Security:090938]Authentication failure: The specified user failed to log in. javax.security.auth.login.FailedLoginException: [Security:090302]Authentication Failed: User specified user denied

  at oracle.security.jps.wls.jaas.module.assertion.WlsUserAssertor.assertUserInternal(WlsUserAssertor.java:113)

  at oracle.security.jps.internal.jaas.module.AbstractUserAssertor.assertUser(AbstractUserAssertor.java:55)

  at oracle.security.jps.internal.jaas.module.assertion.JpsUserAssertionLoginModule.login(JpsUserAssertionLoginModule.java:129)

In Presentation server

[2016-05-31T08:17:09Z] [OBIPS] [ERROR:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: 89bba90b-6423-4895-862f-0d4cb2b0e4c7-00000933,0:1:1] [tid: 33027840] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Odbc driver returned an error (SQLDriverConnectW).

State: 08004.  Code: 10018.  [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.

(08004)

State: HY000.  Code: 43113.  [nQSError: 43113] Message returned from OBIS.

(HY000)

State: HY000.  Code: 13038.  [nQSError: 13038] The user does not have impersonation privilege. (HY000)[[

File:checkauthentication.cpp

Line:1561

Location:

  saw.securitysubsystem.checkauthentication.runimpl

  saw.threadpool.asynclogon

  saw.threads

]]

Any help here would be appreciated very Much

Thanks

Ajay