UTL_SMTP [message #546533] |
Wed, 07 March 2012 05:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/e4aaaa019d9ae6c863c9665d46283396?s=64&d=mm&r=g) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
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
|
|
|
|