LDAP authorization with Oracle (11g/10g).

From: <awatkins1966_at_googlemail.com>
Date: Tue, 5 Aug 2008 14:54:54 -0700 (PDT)
Message-ID: <36f8271f-229b-4342-82c2-684fdc3d948b@34g2000hsh.googlegroups.com>

I am trying to get passwords checked against a LDAP server (not Oracle Internet Directory OID), but after searching the web there does not seem to be a full guide available.

I am using Suns LDAP server for our existing single sign on and I want to include oracle logins into this.

What I have done:
1) Added schema to LDAP server obtained from files below (altered)

$ORACLE_HOME/ldap/schema/oid/oidSchemaCreateBase.sbs
$ORACLE_HOME/ldap/schema/oid/oidSchemaCreateNet.sbs
$ORACLE_HOME/ldap/schema/oid/oidSchemaCreateRDBMS.sbs

2) Added OracleContext to my LDAP server

    "cn=OracleContext, dc=dcs, dc=bbk, dc=ac, dc=uk”

3) SQLNET.ORA
    NAMES.DIRECTORY_PATH=(LDAP) 4) LDAP.ORA
    DEFAULT_ADMIN_CONTEXT = "dc=dcs,dc=bbk,dc=ac,dc=uk"     DIRECTORY_SERVERS = (ldapserver:389:636)     DIRECTORY_SERVER_TYPE = OID 5) SQLPLUS> CREATE USER ANDREW IDENTIFIED EXTERNAL... But what else is required...

Any pointers and if I get it up and running I will post a full step-by- step guide.

Thanks

Andrew Received on Tue Aug 05 2008 - 16:54:54 CDT

Original text of this message