Re: semi OT - Anonymous authentication against AD using DBMS_LDAP
From: Ilmar Kerm <ilmar.kerm_at_gmail.com>
Date: Wed, 11 Jan 2012 21:03:17 +0200
Message-ID: <CAKnHwtfNV_-5UP3Fef5E9OoA2Fx-Nz2Qjbv_szPgPcn5Z_1pKQ_at_mail.gmail.com>
On Wed, Jan 11, 2012 at 8:51 PM, Guillermo Alan Bort <cicciuxdba_at_gmail.com> wrote:
> I am working on a pet project that aims to ease my job a lot, but it
> requires getting information from Active Directory. Using my own DN (which
> was easy enough to find out) I was able to log on to the AD and query just
> about any information I wanted. However now I'm facing the problem of
> authenticating the application using LDAP. The problem here is that the
> sAMAccountName (which is what people usually use to log on to all the apps
> as well as their laptops) is different from the CN in the DN. And as far as
> my testing (and a few hours of google searches) I have to provide the DN in
> order to authenticate.
Date: Wed, 11 Jan 2012 21:03:17 +0200
Message-ID: <CAKnHwtfNV_-5UP3Fef5E9OoA2Fx-Nz2Qjbv_szPgPcn5Z_1pKQ_at_mail.gmail.com>
On Wed, Jan 11, 2012 at 8:51 PM, Guillermo Alan Bort <cicciuxdba_at_gmail.com> wrote:
> I am working on a pet project that aims to ease my job a lot, but it
> requires getting information from Active Directory. Using my own DN (which
> was easy enough to find out) I was able to log on to the AD and query just
> about any information I wanted. However now I'm facing the problem of
> authenticating the application using LDAP. The problem here is that the
> sAMAccountName (which is what people usually use to log on to all the apps
> as well as their laptops) is different from the CN in the DN. And as far as
> my testing (and a few hours of google searches) I have to provide the DN in
> order to authenticate.
You don't need to specify full DN when authenticating against AD, just set it to: username_at_domainname
i:= DBMS_LDAP.simple_bind_s(v_sess, 'ilmker_at_ee.dom', 'very complex password');
-- Ilmar Kerm -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 11 2012 - 13:03:17 CST