I can run following from plsql with sys privileges and I do not have any problem.
SQL> exec utl_mail.send(sender => ' ny@htm.com ', recipients => 'ny@htm.com', subject => 'Testing UTL_MAIL Option', message => 'blah blah blah');
I gave following privileges to public
GRANT EXECUTE ON utl_mail TO PUBLIC
When ordinary user run utl_mail, then there is an error “ORA-24247”. How can I overcome this problem?
SQL> exec utl_mail.send(sender => ' ny@htm.com ', recipients => 'ny@htm.com', subject => 'Testing UTL_MAIL Option', message => 'blah blah blah');
ERROR at line 1:
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_MAIL", line 654
ORA-06512: at "SYS.UTL_MAIL", line 671
ORA-06512: at line 1
Thanks,
NY