Re: Error removing ACE / ACL

  Doug,      

Please check if something like the following   

helps (with relevant entries supplied in the parentheses)?      

exec dbms_network_acl_admin.unassign_acl(…)      

Rajeev         

>
> On Nov 3, 2023 at 8:18 PM, <DOUG KUSHNER (mailto:dougk5_at_cox.net)> wrote:
>
>
>
> 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