3 Replies Latest reply: Apr 17, 2013 1:47 PM by Конурбаев Евгений RSS

    dbms_ldap

    Munish
      Hi,

      We have oracle DB 11g and forms and reports (11.1.2).
      Our clients have Active Directory where all the username and password are stored.

      My question is can I use dbms_ldap package to retrieve that information or do I need OID?

      if anyone have any examples of how to retrieve username and password from MS Active Directory using dbms_ldap package please share it with me.

      Thanks
      Munish
        • 1. Re: dbms_ldap
          vansul
          you can not share password . however you can use the authentication by passing username and password which will give success and failure error level which can be used for further necessary action.
          • 2. Re: dbms_ldap
            Christian Erlinger
            You can use DBMS_LDAP to query Active Directory

            http://docs.oracle.com/cd/E23943_01/oid.1111/e10186/dbmsldap_ref.htm#OIMAD009

            I am not sure if you can retrieve a password; as this would be a huge security flaw I guess the answer to that is no. But you can use dbms_ldap to authenticate against Active Directory.

            Samples can be found on google:

            http://www.google.com/search?q=dbms_ldap+sample

            cheers
            • 3. Re: dbms_ldap
              Конурбаев Евгений
              Here is the example of using DBMS_LDAP:

              http://konurbaev-e.blogspot.ru/2013/04/dbmsldap-example-dbmsldap.html