Oracle Apex 20.1 LDAP authentication with Windows Active Directory

[Zaheer]

Dear Erman,

We need your assistance on fol issue:-


We are making an LDAP authentication scheme with Windows AD on Oracle APEX 20.1
When we give specific OU of user it gets authenticated but user from other OU gives error
LdapErr:DSID-0C090A6C
"In order to perform this operation a successful bind must be completed on the connection"
We are using following search filter
Search filter (&(objectClass=user)(sAMAccountName=%LDAP_USER%))

Hoping for your kind reply at earliest.

Regards

[ErmanArslansOracleBlog]

You have multiple OUs. That's why you should search the whole domain (dn).

You may try the search filters mentioned in here -> https://stackoverflow.com/questions/40474904/how-can-i-authenticate-a-user-in-ldap-within-multiple-ou-with-variable-levels-in

This custom auth mentioned in the below thread seems like the last resort ->

https://community.oracle.com/tech/developers/discussion/2126587/ldap-authentications-across-multiple-ou-groups

Check this one as well -> https://oracle-base.com/articles/misc/oracle-application-express-apex-ldap-authentication

As far as I see, people prefer developing and placing their custom ldap mechanisms with Apex, using DBMS_LDAP.