BEGIN
DBMS_NETWORK_ACL_ADMIN.create_acl (
acl => 'scott_notification.xml',
description => 'Purpose of the acl is to mail any kind of notification set by DBA',
principal => 'scott',
is_grant => TRUE,
privilege => 'connect',
start_date => SYSTIMESTAMP,
end_date => NULL);
END;
/
ERROR at line 1:
ORA-44416: Invalid ACL: Unresolved principal 'scott'
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 226
ORA-06512: at line 2
Solution:
The solution is simple, make the principal uppercase.
BEGIN
DBMS_NETWORK_ACL_ADMIN.create_acl (
acl => 'scott_notification.xml',
description => 'Purpose of the acl is to mail any kind of notification set by DBA',
principal => 'SCOTT',
is_grant => TRUE,
privilege => 'connect',
start_date => SYSTIMESTAMP,
end_date => NULL);
END;
/