I have successfully configured a ReadOnlySQLAuthenticator and see the users and roles in WLS console, extracted from DB. What I cannot understand is why the mappings between user and their roles are not correctly done by ReadOnlySQLAuthenticator. The queries for "SQL is Member" and "SQL List Member Groups" are correct like the other SQLs skripts, but the mapping are missing, which causes that ADF Security can not initialize the roles of an authenticated user in the ADF SecurityContext. Any idea what can be the issue and how to solve it?
thanks for the repply. After tests I found that the Integration of the SecurityProviders was not working because of different Passwords on LDAP and DB-level.. I was irretated, since I expected to see the member groups of each user, delivered from the ReadOnlySQLAuthenticator..