I'm having a problem when using ADF Security + SQL authentication, follow these instructions:
Jdev, I create an App and use the "Configure ADF Security ...", when deploying and log (login.html) on my WL trouble is:
Just signed the non-SQL authentication user, the user uses "SQL authentication" error message "Invalid username or password" (error.html).
Can anyone help?
Thanks in advance.
I assume you deploy to a stand-alone WLS instance. Make sure the SQL authentication provider is configures as sufficient so that the user in the SQL source is not required to successfully pass the integrated LDAP. Also you want to make the SQL authentication provider the first in the list
I'm using JDEV 22.214.171.124.0 and deploy stand-alone WLS instance
I have successfully configured on a stand-alone WLS instance for users in DB
and also the following url: http://hazem-adf-tips.blogspot.com/2012/06/adf-security-database-authentication.html
But still no success.
Thanks and Regards
Edited by: ltthoi on Nov 30, 2012 12:35 AM
First check if your SQLAuthenticator retrieves users(and groups).
You can check this in tab Users and groups (or Utilisateurs et groupes :) ) http://1.bp.blogspot.com/-a0IbrIpX4nM/T9IL3cusiGI/AAAAAAAAAOg/H_2jve4nlb4/s1600/sqlAuthenticator_step3.png
If you see users from your db, then set SUFFICIENT to your authentication providers(both default and SQLAuthenticator) and restart WLS
I have configured and see the users and groups in the DB on the WL, but use JDEV 126.96.36.199.0 follow the url above is not logged in as a user "SQL authentication".
Edited by: ltthoi on Nov 30, 2012 12:59 AM