Re: semi OT - Anonymous authentication against AD using DBMS_LDAP

  • From: Ilmar Kerm <ilmar.kerm@xxxxxxxxx>
  • To: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 11 Jan 2012 21:03:17 +0200

On Wed, Jan 11, 2012 at 8:51 PM, Guillermo Alan Bort
<cicciuxdba@xxxxxxxxx> 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@domainname

i:= DBMS_LDAP.simple_bind_s(v_sess, 'ilmker@xxxxxx', 'very complex password');

-- 
Ilmar Kerm
--
//www.freelists.org/webpage/oracle-l


Other related posts: