Sybrand, would you please stop being such an unsociable wanker to the new
and less knowledgeable (nay, mortal) posters in this group. You are creating
a bad image for this group and quite frankly you come accross as a
frustrated rude bad mannered pig...
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:ghe6ius2uealcj1bnlmsdk5upk4ov1784n_at_4ax.com...
> On Wed, 03 Jul 2002 13:30:48 GMT, nigel.hurst_at_food.ds-s.com (dnh)
> wrote:
>
> >
> >Hi
> >
> >we're a bit stick on this, any help appreciated.
> >
> >We're calling dms_session.set_context from a pkg procedure and we are
> >getting the old 1031, insufficient privilege error on line 58 of
> >set_context.
> >
> >Firstly, we do have alter session so it's not that. I tried looking to
> >see what line 58 was doing but it's a wrapped pkg so we cvan't seeit.
> >
> >We're obviously missing a grant somewhere but can't find it - does
> >anyone have any ideas??
> >
> >nigel
> >
> >---
> >Take out food to reply to nigel.food.hurst_at_ds-s.com
> >-------------------------------------------------
> >Take out food to reply to nigel.hurst_at_food.ds-s.com
> >-------------------------------------------------
>
>
> This is sooooooooooooo......... boring
> If people would search the archives that would reduce the traffic in
> this group with 80 percent, and the small bunch of people responding
> here wouldn't have to waste their time to repeat the same answer over
> and over again.
> Without being able to post an exact answer (evidently specifying your
> version was asked just too much): you have privilege through a *role*
> as roles are volatile they are *ignored* during compilation of stored
> procedures.
> Either a) create your procedure with authid current_user (8.1 and
> higher), or b) grant the alter session privilege directly (8.0 and
> before)
>
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sat Jul 06 2002 - 17:07:35 CDT
