This discussion is archived
2 Replies Latest reply: Nov 16, 2012 7:11 AM by nbo RSS

ADF Security: User to Role mappings with ReadOnlySQLAuthenticator

nbo Newbie
Currently Being Moderated
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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points