Re: ACLS oracle 11 UTL_MAIL.

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 4 Mar 2013 06:37:50 +0000
Message-ID: <CABe10sbc=MJSo17bG5DdA0iUTWH5NWSbaSC1=G1DHUM5571mEQ_at_mail.gmail.com>

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_at_gmail.com>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_at_constellation.com> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org]
> > 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
> >
> >
> > --
> > http://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
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 04 2013 - 07:37:50 CET