Re: insufficient privilege to create temp table from stored proc

Thanks for the answer Cameron,

After trawling a little through DejaNews it looks like this is practically a FAQ-type question. Unfortunately we're in a blind leading the blind situation here. I, as the user haven't used Oracle since the early 90's (version 5 I think, running on a 286 PC). The IT people, who for now are playing the DBA role, have little experience and no training.

Jon

"Cameron Hutchison" <camh_at_zip.com.au> wrote in message news:pan.2002.02.12.12.44.14.672143.5011_at_zip.com.au...
> On Tue, 12 Feb 2002 03:10:45 +1100, Jon Waterhouse wrote:
>
> > I am trying to create a temporary table, which works fine in SQL-PLUS,
> > but gives me an insufficient privilege error when run as below in a
> > stored procedure.
> > Any idea what privilege I'm missing. I've been going round and round int
> > he help for about half an hour.
>
> Chances are that you have the "CREATE TABLE" system privilege through the
> old-but-still-used RESOURCE role. Your procedures do not get the
> privileges assigned through roles, so you will need to grant the
> "CREATE TABLE" system privilege directly to the user that owns the
> stored procedure.
>
> CHeers
Received on Tue Feb 12 2002 - 09:42:39 CST