SQL> begin
DBMS_NETWORK_ACL_ADMIN.create_acl(
acl => '/sys/acls/AddressDoc.xml',
description=>'ACL for UTL_MAIL',
principal=>'STAT_CUSTGOV',
is_grant=>TRUE,
privilege=>'connect');
COMMIT;
End;
/ 2 3 4 5 6 7 8 9 10
PL/SQL procedure successfully completed.
SQL> BEGIN
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => '/sys/acls/AddressDoc.xml',
host => '*');
COMMIT;
END;
/ 2 3 4 5 6 7
PL/SQL procedure successfully completed.
SQL> BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE (
acl => '/sys/acls/AddressDoc.xml',
principal => 'STAT_CUSTGOV',
is_grant => TRUE,
privilege => 'connect');
END;
/
PL/SQL procedure successfully completed.
DBMS_NETWORK_ACL_ADMIN.create_acl(
acl => '/sys/acls/AddressDoc.xml',
description=>'ACL for UTL_MAIL',
principal=>'STAT_CUSTGOV',
is_grant=>TRUE,
privilege=>'connect');
COMMIT;
End;
/ 2 3 4 5 6 7 8 9 10
PL/SQL procedure successfully completed.
SQL> BEGIN
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => '/sys/acls/AddressDoc.xml',
host => '*');
COMMIT;
END;
/ 2 3 4 5 6 7
PL/SQL procedure successfully completed.
SQL> BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE (
acl => '/sys/acls/AddressDoc.xml',
principal => 'STAT_CUSTGOV',
is_grant => TRUE,
privilege => 'connect');
END;
/
PL/SQL procedure successfully completed.
No comments:
Post a Comment