ADF/SOA Authentication based on Data Base

User_BUYLR

Hi team,

Jdev : 12.2.1.2.0

Our application authentication happened from LDAP and email triggers (task assignments for soa/bpm ) happened through LDAP (which has been configured in WebLogic server) but now the client wants to Data base based authorizations and task assignment feature.

Can anyone let us know how we can achieve this?

Timo Hahn

You can use an SQL Authenticator as shown here https://technology.amis.nl/it/using-database-table-for-authentication-in-adf-applications/ and here https://adfsolutions.anirbanblogs.com/2018/11/sql-authentication-provider-for-adf.html or https://middleware-home.blogspot.com/2016/09/implementing-sql-authenticator-to.html

Timo

User_BUYLR

Hi Timo,

Thanks for your quick reply.

We tried above one. But we need like as

--> we have SAML authentication so application login should be handle with SAML (SS)

--> Authorization should be based on Data Base tables and roles we should get from Data base only.

This how we can do that

Timo Hahn

You can write your own authorization provider and integrate it into your WLS. USer the SAML authentication provider from WLS and your own authorization provider querying the db tables as you like.

Search for 'oracle weblogic authorization provider' to get help what t do and how.

Timo