Oracle 12c ACL Odd behaviour.
Hi,
I'm setting up my first 12c database. On creating the ACL I experienced some unexpected behaviour.
So for example I do the following:
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
acl => 'sasa-permissions.xml',
description => 'Network permissions for sasa.net',
principal => 'CONNECT',
is_grant => TRUE,
privilege => 'connect');
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
acl => 'sasa-permissions.xml',
principal => 'CONNECT',
is_grant => true,
privilege => 'resolve');
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
acl => 'sasa-permissions.xml',
principal => 'CONNECT',
is_grant => true,
privilege => 'connect');
END;
/
begin
dbms_network_acl_admin.assign_acl (
acl => 'sasa-permissions.xml',
host => 'localhost');
end;
/
Now first odd behaviour is that in 11g I would normally check the following to make sure the ACL is created: