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
