Re: 1031, insufficent priv error & dbms_session.set_context line 58

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 Wed Jul 03 2002 - 12:57:58 CDT