jump to navigation

Grant ACL permission for UTL_SMTP to be used in 11g database May 17, 2009

Posted by sendtoshailesh in Uncategorized.
Tags:
trackback


After some searching it was clear that you need to create an Access Control List to provide access from within the database to allow connects to be made.
Despite of some information i found on this topic , the only thing i needed to provide this access to the MAILUSER was to execute these command as the sys user.


EXECUTE DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('acl_for_mail.xml', 'ACL for Mail Job','MAILUSER', TRUE, 'connect');
EXECUTE DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('acl_for_mail.xml','localhost', 25);
COMMIT;

You might want to grant this UTL_SMTP to the MAILUSER ,

grant execute on UTL_SMTP to MAILUSER;

Grant succeeded.

Advertisements

Comments»

1. chris - June 2, 2011

Thanks for this, saved me a lot of messing around

2. kodav - August 5, 2011

Thank you! Saved me quite a bit of time and blushes.

The suggestion was concise and relevant.

Thanks, Shailesh.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: