LDAP with ORACLE

SQL> conn / as sysdba

SQL> @?/rdbms/admin/catldap.sql

BEGIN
  DBMS_NETWORK_ACL_ADMIN.create_acl (
    acl          => 'ldap_acl_file.xml', 
    description  => 'ACL to grant access to LDAP server',
    principal    => 'APEX_190200', --授予该用户ACL权限，如果使用apex内嵌LDAP认证则这里设置为APEX_190200，如果自己编写认证过程，则自主选择用户
    is_grant     => TRUE, 
    privilege    => 'connect',
    start_date   => SYSTIMESTAMP,
    end_date     => NULL);

  DBMS_NETWORK_ACL_ADMIN.assign_acl (
    acl         => 'ldap_acl_file.xml',
    host        => '*', 
    lower_port  => 389,
    upper_port  => 389);

  DBMS_NETWORK_ACL_ADMIN.assign_acl (
    acl         => 'ldap_acl_file.xml',
    host        => '*', 
    lower_port  => 686,
    upper_port  => 686);

  COMMIT;
END;
/


--删除权限如下
BEGIN
    dbms_network_acl_admin.drop_acl(acl => 'ldap_acl_file.xml');
END;
/