This content has been marked as final. Show 4 replies
There is no built-in Active Directory authentication scheme. There is a built-in LDAP scheme which, if you provide the right DN, will work in most environments where you have AD. Search this forum for Active Directory.
That correct I am using the LDAP scheme, and providing it with the appropriate DN string. The only problem is that it allways says authentication failed, without giving any error messages. So I tried with some success to test the LDAP packages provided by oracle.
I am able to authenticate using dbms_ldap, but that only works when I provide NULL for a password.
DBMS_LDAP.use_exception := TRUE;
vSession := DBMS_LDAP.init
( hostname => 'CREDPWY01SDCG01'
, portnum => 389
vResult := DBMS_LDAP.simple_bind_s
( ld => vSession
, dn => 'CN=<username>,dc=credit,dc=com'
, passwd => NULL
vResult := DBMS_LDAP.unbind_s(vSession);
I am not able to authenticate at all when using apex_ldap regardless if I pass NULL for the password, or use the real password.
( p_username => '<username>'
, p_password => NULL
, p_search_base => 'dc=credit,dc=com'
, p_host => 'CREDPWY01SDCG01'
, p_port => 389
That did the trick. Instead of using a standard DN string 'cn=%LDAP_USER%, dn=mydomain, dn=com' you just use the following string mydomain\%LDAP_USER%