Use database table for authentication in adf security

To use sql authenticator in weblogic server security realm, read following blog post:  SQLAuthenticator

Now go to application and apply adf security. You do not need to modify the role mapping in weblogic.xml. The default is perfectly fine:

  
    valid-users
    users
  
 

For each group in your SQLAuthenticator provider in weblogic console, create an equivalent application role in jazn.xml, and recreate those roles in the Enterprise Roles in jazn.xml. In jazn,xml make enterprise role as member of the appropriate application role. There is no need to create user in jazn.xml file. Crating role will do the work.