DBMS_NETWORK_ACL_ADMIN.remove_host_ace problems
Hi Guys,
I have oracle database 12.1.0.2.0 on windows 2012. We have multiple server setup for util_http to use, not anymore valid. I try run script remove these hosts, I have error ( I connected with sys account; the ACl priv were assigned by privs too) check below
-----------------------------------
SQL> BEGIN
2 DBMS_NETWORK_ACL_ADMIN.remove_host_ace (
3 host => 'houapps371',
4 lower_port => 1,
5 upper_port => 1000,
6 ace => xs$ace_type(privilege_list => xs$name_list('CONNECT
'),
7 principal_name => 'IPMSPROD',
8 principal_type => xs_acl.ptype_db),
9 remove_empty_acl => TRUE);
10 END;
11 /
BEGIN
*
ERROR at line 1:
ORA-01927: cannot REVOKE privileges you did not grant
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 1158