UTL_MAIL ORA-24247

On 18. September 2012

ORA-24247: network access denied by access control list (ACL)

Folgende Seite beschreibt anschaulich die Problematik der Oracle ACLs:

http://blog.whitehorses.nl/2010/03/17/oracle-11g-access-control-list-and-ora-24247/

Create ACL:

begin
  dbms_network_acl_admin.create_acl (
    acl         => 'utl_mail.xml',
    description => 'Allow mail to be send',
    principal   => 'SCOTT',
    is_grant    => TRUE,
    privilege   => 'connect'
    );
    commit;
end;

Add Privilege:

begin
  dbms_network_acl_admin.add_privilege (
  acl       => 'utl_mail.xml',
  principal => 'SCOTT',
  is_grant  => TRUE,
  privilege => 'resolve'
  );
  commit;
end;
Assign ACL:
begin
  dbms_network_acl_admin.assign_acl(
  acl  => 'utl_mail.xml',
  host => 'smtp server host name or address'
  );
  commit;
end;

Schreibe einen Kommentar