2 Replies Latest reply: Nov 16, 2012 9:11 AM by nbo RSS

    ADF Security: User to Role mappings with ReadOnlySQLAuthenticator

    nbo
      Hello

      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 ins advance!