ORA-44416 Unresolved Principal

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;

/