=================

BEGIN

dbms_network_acl_admin.create_acl (

acl => 'smtp_permissions.xml', -- or any other name

description => 'SMTP Access',

principal => 'CHADMOON', -- the user name trying to access the network resource

is_grant => TRUE,

privilege => 'connect',

start_date => null,

end_date => null

);

commit;

END;

===================

BEGIN

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'smtp_permissions.xml',

principal => 'CHADMOON',

is_grant => true,

privilege => 'connect');

commit;

end;

==============================

BEGIN

dbms_network_acl_admin.assign_acl (

acl => 'SMTP_permissions.xml',

host => 'smtp.sendgrid.net', /*can be computer name or IP , wildcards are accepted as well for example - '*.us.oracle.com'*/

lower_port => 25,

upper_port => 25

);

END;

=================

SELECT *

FROM dba_network_acl_privileges

where principal='CHADMOON';