Skip to content

Instantly share code, notes, and snippets.

@ajin

ajin/smtp-acl-oracle-apex.sql

Created February 1, 2016 20:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save ajin/fdd8167799f9d307537d to your computer and use it in GitHub Desktop.
Save ajin/fdd8167799f9d307537d to your computer and use it in GitHub Desktop.
Download ZIP
Setting up ACL for sending email on Oracle APEX 5
Raw
smtp-acl-oracle-apex.sql
begin
dbms_network_acl_admin.create_acl (
acl => 'smtp-permissions.xml',
description => 'Permissions for smtp',
principal => 'APEX_050000',
is_grant => true,
privilege => 'connect');
commit;
end;
/
begin
dbms_network_acl_admin.assign_acl (
acl => 'smtp-permissions.xml',
host => '<smtpserver>',
lower_port => 25,
upper_port => NULL);
commit;
end;
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment