Re: Error removing ACE / ACL

That did the trick. Thank you!    

> On 11/03/2023 5:42 PM MST Rajeev Prabhakar <rprabha01_at_gmail.com> wrote:
>
>
>
> 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