UTL_SMTP [message #546533] |
Wed, 07 March 2012 05:29 |
|
sathish16787
Messages: 56 Registered: September 2011 Location: mumbai
|
Member |
|
|
Hi,
I try to send mail using utl_smtp .with sys user am able to send But normal user i am not able to send .Below error is showing
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 246
ORA-06512: at "SYS.UTL_SMTP", line 127
ORA-06512: at "SYS.UTL_SMTP", line 150
ORA-06512: at "LMS1.SEND_MAIL_SMTP", line 13
ORA-06512: at line 2
Thanks,
Sathish
|
|
|
|
Re: UTL_SMTP [message #546539 is a reply to message #546533] |
Wed, 07 March 2012 05:43 |
|
Michel Cadot
Messages: 68718 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
11g introduced the ACL (Access Control List) for TCP accesses.
You must grant these accesses to your account (in addition to have granted it the privilege to execute the procedure):
begin
dbms_network_acl_admin.create_acl (
acl => 'utl_mail.xml',
description => 'Allow mail to be sent',
principal => 'MICHEL',
is_grant => TRUE,
privilege => 'connect'
);
dbms_network_acl_admin.add_privilege (
acl => 'utl_mail.xml',
principal => 'MICHEL',
is_grant => TRUE,
privilege => 'resolve'
);
dbms_network_acl_admin.assign_acl (
acl => 'utl_mail.xml',
host => '<your smtp server host name or address>'
);
commit;
end;
/
Replace MICHEL by your account.
Regards
Michel
|
|
|
|