Andrew That's a nice solution to this issue. I see a couple of potential improvements to the trigger presented in the blog now it has a wider audience, like me, though. First there's the host='*' line which should likely be replaced with host='smtp.server.fqdn' :) and second, a useful exercise for the reader is the revoking of the ACL when REVOKE EXECUTE on UTL_MAIL is issued, or at least how to deal with this should be mentioned. On Thu, Feb 28, 2013 at 8:19 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>wrote: > I was going to say its no big deal to drop and re-create xdb, but I see > someone has already noted that it can be done. Just be sure to follow the > notes exactly. By the way, on my blog I have a little database trigger I > wrote a couple of years ago for creating or adding to the network acl when > you grant execute on utl mail. Your pardon if my blog comments are a > little snarky on this, its not my favorite feature of 11gR2. > > http://dbakerber.wordpress.com/2011/06/29/11gr2-network-acl-what-a-nice-feature/ > > > > On Thu, Feb 28, 2013 at 2:12 PM, Jorgensen, Finn < > Finn.Jorgensen@xxxxxxxxxxxxxxxxx> wrote: > > > Whenever I have this problem I drop XDB and recreate it but you will need > > to bounce the database between those 2 actions. There's a MOS note about > > the scripts to run to properly drop and recreate XDB. > > > > Thanks, > > Finn > > > > > > -----Original Message----- > > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] > > On Behalf Of Howard Latham > > Sent: Thursday, February 28, 2013 2:59 PM > > To: ORACLE-L > > Subject: ACLS oracle 11 UTL_MAIL. > > > > 11.2 Redhat LInux. > > I've migrated to 11g . I use email. So I need to set up acls but the > > XDB portion of the database is invalid and was when it was a 10 db. > > > > What would you do? Can XDB be dropped and recreated? > > > > I will set up a SR but just wonderd if anyone had this problem and a > quick > > way of sorting it. > > > > -- > > Howard A. Latham > > > > > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > This e-mail and any attachments are confidential, may contain legal, > > professional or other privileged information, and are intended solely for > > the > > addressee. If you are not the intended recipient, do not use the > > information > > in this e-mail in any way, delete this e-mail and notify the sender. > -EXCIP > > > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > > > > -- > Andrew W. Kerber > > 'If at first you dont succeed, dont take up skydiving.' > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Niall Litchfield Oracle DBA http://www.orawin.info -- //www.freelists.org/webpage/oracle-l