4 Replies Latest reply on Aug 7, 2014 5:03 AM by roobie

    questions regarding LDAP config


      Hi everyone,


      Using APEX 4.2, RDBMS 11gR2.


      I've been trying to configure for APEX to authenticate users against Active Directory following a number of posts in the forum but have not bee successful. Appreciate if someone can help. Below is my server details (I've substituted my server/domain with example.com):


      Domain: example.com


      Distinguished Name (DN): CN=First Last,OU=HQ,OU=User Accounts,DC=example,DC=com


      sAMAccountName: flast


      I have used the DN string above to authenticate using the simple_bind_s function in the DMBS_LDAP package and that works fine in APEX SQL Workshop and SQL Developer.


      I've tried in APEX by specifying in the DN field with the following but it does not work:

      cn=%LDAP_USER%,OU=HQ,OU=User Accounts,DC=example,DC=com


      Have also tried in APEX the following as well but still doesn't work (as some posts suggest):

      example%LDAP_USER%,OU=HQ,OU=User Accounts,DC=example,DC=com

      example\%LDAP_USER%,OU=HQ,OU=User Accounts,DC=example,DC=com

      example/%LDAP_USER%,OU=HQ,OU=User Accounts,DC=example,DC=com

      cn=example%LDAP_USER%,OU=HQ,OU=User Accounts,DC=example,DC=com

      .. and many more variations


      Also tried this



      and this



      Can anyone advise what else I should try?


      Thanks in advance