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