Page 1 of 1

LDAP authentication using Active Directory

Posted: Mon Jul 13, 2020 2:56 am
by admin
ACL

BEGIN
DBMS_NETWORK_ACL_ADMIN.create_acl (
acl => 'erpstuff_acl.xml',
description => 'ACL for LDAP',
principal => 'APEX_2002000', << APEX current version username
is_grant => TRUE,
privilege => 'connect',
start_date => SYSTIMESTAMP,
end_date => NULL);

DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => 'erpstuff_acl.xml',
host => 'X.X.X.X', << ip of your ldap server
lower_port => 389, << port no
upper_port => NULL);

COMMIT;
END;

Authentication Schemes

IP address of AD server
Port : 389
SSL : No SSL (if no SSL)
Distinguished Name (DN) String(Value Required) : domain\%LDAP_USER%
Use Exact Distinguished Name (DN) : Yes

Authorization Schemes