Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, sandeep.

Asked: August 09, 2016 - 3:00 pm UTC

Last updated: August 10, 2016 - 1:30 am UTC

Version: 12c

Viewed 1000+ times

You Asked

Hi,

I have a schema which uses the ACL like below to send mails.The ACL gets dropped ocassionally and application using teh schema is unable to send the mails.We need to manually add the ACL again and everything gets back to normal.Can anyone experienced this issue ?Provide the solution if there is any ??

/sys/acls/xxxxxxxx_smtp.xml

and Connor said...

I've never seen that ... Are you creating the ACL with the new 12c usage ?

You should be using:

DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE

Let us know if that helps.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

DBMS_NETWORK_ACL_ADMIN

More on PL/SQL routine DBMS_NETWORK_ACL_ADMIN here