LDAP Authentication with users from different OU on Oracle APEX
On My company, the LDAP Administrator wanted to organize the users in the LDAP directory creating Organization Units (OU) for different groups of users, this made to fail my authentication scheme because it authenticated against the DN cn=%LDAP_USER%,ou=users,dc=company,dc=local but I had users in the DN cn=%LDAP_USER%,ou=CityA,ou=users,dc=company,dc=local , they couldn't authenticate on the app. In my environment, I have APEX 19.1, and Oracle 11G R2. APEX has a built-in LDAP Authentication method where you can add the parameters to connect to the LDAP, one of those parameters is "Use Exact Distinguished Name (DN)" if you set this to "No", you can use a filter to find the user, but trying to use it I got this error: In order to perform this operation a successful bind must be completed on the connection. This is because I need a bind connection to perform searches, but fixing this was out of my hands, if you don't have this problem or you can modify the