How to create network ACL in oracle apex?
Login to your database as a dba & run the below code.
BEGIN
DBMS_NETWORK_ACL_ADMIN.append_host_ace (
host => 'api.docparser.com',
lower_port => NULL ,
upper_port => NULL ,
ace => xs$ace_type(privilege_list => xs$name_list('connect', 'resolve'),
principal_name => 'YOURSCHEMA_USERNAME',
principal_type => xs_acl.ptype_db));
END;
DBMS_NETWORK_ACL_ADMIN.append_host_ace (
host => 'api.docparser.com',
lower_port => NULL ,
upper_port => NULL ,
ace => xs$ace_type(privilege_list => xs$name_list('connect', 'resolve'),
principal_name => 'YOURSCHEMA_USERNAME',
principal_type => xs_acl.ptype_db));
END;
Comments
Post a Comment