I am attempting to set up an ACL in order to make restful POST. I have run the below code but continue to keep getting a 01031. 00000 - "insufficient privileges" message when I run the utl_http.request.
grant execute on utl_http to DBO;
grant execute on dbms_lock to DBO;
BEGIN
DBMS_NETWORK_ACL_ADMIN.create_acl (
acl => 'test_6.xml',
description => 'A test of the ACL functionality',
principal => 'DBO',
is_grant => TRUE,
privilege => 'connect',
start_date => SYSTIMESTAMP,
end_date => NULL);
end;
begin
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => 'test_6.xml',
host => 'us-central1-recruiting-297022.cloudfunctions.net',
lower_port => 1522,
upper_port => NULL);
end;