LDAP authorization with Oracle (11g/10g).
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