ACL Lists ... sqlplus on remote server
Hi there
I try to use utl_http via sqlplus and I have the following situation:
Server A:
Oracle 12.2.0.1 SID: TEST
sqlplus installed
Server B:
sqlplus installed
Server A: SID=TEST
SQL> BEGIN
dbms_network_acl_admin.append_host_ace(
host => 'balooweb.xxx.xx',
lower_port => null,
upper_port => null,
ace => xs$ace_type(privilege_list => xs$name_list('connect','resolve','http'),
principal_name => 'TSTUSER',
principal_type => xs_acl.ptype_db) );
EXCEPTION WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Error while granting ACL :'|| SQLERRM);
END;
/
SQL>connect TSTUSER;
SQL> select utl_http.request ('http://balooweb.xxx.xx:8889/') from dual;