Hi,
I mistakingly added the default user ORACLE_OCM to an ACL using:
BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE
('acl.xml','ORACLE_OCM',TRUE,'connect');
commit;
end;
/
I have tried the following :
Begin
DBMS_NETWORK_ACL_ADMIN.DELETE_PRIVILEGE ('acl.xml','ORACLE_OCM',FALSE,'connect');
commit;
end;
/
The procedure completed successfully. However the following query still returns the user with the 'connect' privilege on the list
select principal, acl, privilege from dba_network_acl_privileges;
-------------------- ----------------------------------- ----------
| ORACLE_OCM | /sys/acls/acl.xml | connect |
Please advise on how to take this off.
thank you.