linkedin_slack_create_acl.sql

begin
 dbms_network_acl_admin.create_acl (
   acl        => 'utl_https_slack.xml',
   description => 'Slack HTTPS Access',
   principal  => 'SLACK',
   is_grant   => TRUE,
   privilege  => 'connect',
   start_date => null,
   end_date   => null
 );


 dbms_network_acl_admin.add_privilege (
   acl       => 'utl_https_slack.xml',
   principal => 'SLACK',
   is_grant  => TRUE,
   privilege => 'resolve',
   start_date => null,
   end_date  => null
 );

dbms_network_acl_admin.assign_acl (
   acl       => 'utl_https_slack.xml',
   host      => '*.slack.com',
   lower_port => 443,
   upper_port => 443
 );

 commit;

end;
/