APEX

Dear All

As a newbie to APEX with an ambitious desire to get it to work with LDAP I came accross a rather irritating aspect of using LDAP. In our company we have many SBU's and many domain servers. Where in Windows you just login by entering DOMAIN\USER this appears to be more complicated with LDAP. In certain cases the Common Name in LDAP over here is configured as the user's full name, where in other cases it is indeed the same as the login user to Windows (eg. John Doe [vs.] JDOE]. It appears that what DOMAIN\USER is referring to, is the Active Directory SAMAccountName. So, currently LDAP will work great for the domain I reside in, but I can't see a way of making it compatible with all the other domains... :/

So my question is: assuming a user will login to APEX with LDAP and I ask them to login with DOMAIN\SAMACCOUNTNAME, how do I make LDAP work this way? It appears to me that it requires some advanced LDAP querying prior to logging in the user to retrieve the user's DN first and then bind with the user's credentials?

Do any of you have an approach to this situation? Anyone know which functions to use in DBMS_LDAP to perform such queries? I'm neither an APEX nor an LDAP expert, but I am very much looking into understanding what's involved. I know it's a rather broad subject to dive into like this, but that shouldnt stop me - or should it? :)


Much appreciate your thoughts!


Tom