Error removing ACE / ACL
From: DOUG KUSHNER <dougk5_at_cox.net>
Date: Fri, 3 Nov 2023 17:16:32 -0700 (MST)
Message-ID: <1303582672.222721.1699056992915_at_myemail.cox.net>
Database is 19.20, most likely migrated from 11.2.0.4.
END; Error at line 1
Date: Fri, 3 Nov 2023 17:16:32 -0700 (MST)
Message-ID: <1303582672.222721.1699056992915_at_myemail.cox.net>
Database is 19.20, most likely migrated from 11.2.0.4.
Trying to remove host ACE that has has NULL ACL and ACL_OWNER columns and no associated rows in dba_network_acl_privileges. Any ideas for surgically removing this network ACL?
SQL> select * from sys.dba_network_acls where acl is null;
HOST LOWER_PORT UPPER_PORT ACL ACLID ACL_OWNER
------------------------- ---------- ---------- ---------- ---------------- ----------
myserver02 8071 8071 0000000080002761
SQL> select * from sys.dba_network_acl_privileges where aclid = '0000000080002761';
no rows selected.
As SYS user:
BEGIN
DBMS_NETWORK_ACL_ADMIN.REMOVE_HOST_ACE(
host => 'myserver02', lower_port => 8071, upper_port => 8071, ace => xs$ace_type(privilege_list => xs$name_list('connect'), principal_name => 'MY_PRINCIPAL_NAME', principal_type => xs_acl.ptype_db),remove_empty_acl => TRUE);
END; Error at line 1
ORA-01927: cannot REVOKE privileges you did not grant ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 1222 ORA-06512: at line 2
Regards,
Doug
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Nov 04 2023 - 01:16:32 CET