Dear all,
I have created a ACL for the first time, but the user that tries to connect to the destination host can't connect.
The failure, which he receives is: ORA-31204: DBMS_LDAP: PL/SQL - Invalid LDAP Session
I have used the following commands to create this ACL:
SQL> exec DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('ACL_SID_APEX.xml', 'description', 'developer_username', TRUE, 'connect');
SQL> exec DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('ACL_SID_APEX.xml' ,'developer_username', TRUE, 'resolve');
SQL> exec DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('ACL_SID_APEX.xml' ,'APEX_050000', TRUE, 'connect');
SQL> exec DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('ACL_SID*_APEX.xml' ,'APEX_050000', TRUE, 'resolve');
SQL> exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('ACL_SID_APEX.xml','destination-hostname');
SQL> exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('ACL_SID_APEX.xml','*');
I have added the privilege to the APEX admin user and also to the user, which is used for the outgoing connection.
Also, I have assigned the ACL to the destination host directly, but also by using the wildcard '*'.
Is this creation and assigning of the ACL correct? Or is anything missing?
Kind regards, Marcel