This content has been marked as final. Show 2 replies
the block you've copied and adapted only grants the connect privilege to your user. For what you are up to, you'll also need resolve to make it work. Run something like
assuming your previous script created the "power_users.xml". change the ACL name accordingly.
BEGIN DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE( acl => 'power_users.xml', principal => 'MATTHIASH', is_grant => TRUE, privilege => 'resolve'); END; / COMMIT;
For more details, see the [url http://docs.oracle.com/cd/E14072_01/appdev.112/e10577/d_networkacl_adm.htm]API Doc for DBMS_NETWORK_ACL_ADMIN.
Ok, this worked fine!