Authentication to OAM from Database using OVD

1.This post is to show how to make the oracle database as a authentication store to Oracle Access Manager using Oracle Virtual Directory(OVD).
2.Create a table in the database with required fields as username,password
3.Create an adapter in the OVD to map the database as shown below
3.1 Login in to OVD from ODSM.
3.2 Click on the Adapter tab and click on the Create New Adapter icon.

3.3 select Database as Adapter Type,Give any name, here i have given name as OAMDBAdapter and select Adapter Template as OAM/DB Adapter with script Script

3.4 Provide Name Space which will be used as a user base in OAM. select url type and database type based on your database.Provide the host name,port,database name,database user where the table with user details like username,password exists.

3.5 Brownse and select the Table where username and password details exists.

3.6 Map the cn,uid,userpassword with the database fields.

3.7. Mapping uid with userid similarly map cn with userid

3.8. Mapping userpassword with Passsword

3.9 Click on next

3.10 Verify the details and click on the finish.

3.11 click on the data browser tab and expand the dc=dbuser,dc=example,dc=com to verify the created users in the database table listed over here.

4. OAM configurations,Login to OAM admin console and click on the system configurations tab.Go to Data sources and click on the User Identity Stores then click on the create new icon to create a new user store for the database users.Provide the OVD details as shown in the figure.

4.1 Verify the Connection.

4.2 ore.Expand the Access Manager settings and Authentication module then click on create Create a new LDAP Authentication module and specify the testdb identity store and provide a name

4.3 Go to Policy Configurations tab and create new or choose existing LDAP Autentication scheme and provide the above created Authetication module.

4.6 Now all the protected resources with LDAP authentication scheme will be able to login wiht the users from the database.