Home » RDBMS Server » Server Administration » UTL_SMTP (oracle 11g)
UTL_SMTP [message #546533] Wed, 07 March 2012 05:29 Go to next message
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 #546538 is a reply to message #546533] Wed, 07 March 2012 05:42 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
It's all ion the docs,
http://docs.oracle.com/cd/E11882_01/network.112/e16543/authorization.htm#CIHIIBGH
Re: UTL_SMTP [message #546539 is a reply to message #546533] Wed, 07 March 2012 05:43 Go to previous messageGo to next message
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
Re: UTL_SMTP [message #546815 is a reply to message #546539] Fri, 09 March 2012 01:55 Go to previous message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
thanks issue is solved
Previous Topic: Oracle and Active Directory services
Next Topic: how to find updated table
Goto Forum:
  


Current Time: Sun Dec 01 14:22:18 CST 2024