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;
/

Comments