BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'Email_Access.xml',
description => 'Enable Network',
principal => 'CHADMOON',
is_grant => true,
privilege => 'connect',
START_DATE => SYSTIMESTAMP,
END_DATE => NULL
);
COMMIT;
END;
/
****************************************************************
BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl => 'Email_Access.xml',
host => 'smtp.sendgrid.net');
lower_port => 25,
upper_port => NULL
);
COMMIT;
END;
/
****************************************************************
BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'Email_Access.xml',
principal => 'CHADMOON',
is_grant => true,
privilege => 'connect');
COMMIT;
END;
/
****************************************************************
SELECT * FROM dba_network_acls;
SELECT * FROM dba_network_acl_privileges
where principal='CHADMOON';
