Database Security Products (MOSC)

MOSC Banner

DBMS_NETWORK_ACL_ADMIN.remove_host_ace problems

edited Apr 12, 2018 11:27AM in Database Security Products (MOSC) 5 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center