OBIEE 10g - We have implemented security using the impersonator and NO LDAP server. In 10g when users are added in the extertal database table, SSO Authentication was working perfect.
OBIEE 11g - When upgraded using upgrade utility(NO LDAP server) -
Case 1- When users are added in both wls console and external table , then SSO authentication is working.
Case 2- When users are not added in wls console and added in external table, then SSO Authentication failed and login page pops up.
Can anyone please suggest how to implement security without adding users in wls console (only with external database table) ??