Re: insufficient privilege to create temp table from stored proc

I did say "almost".

But can't use use CONTEXT to do the same thing?

Daniel Morgan

Marc Blum wrote:

> On Mon, 11 Feb 2002 17:17:21 GMT, damorgan
> <dan.morgan_at_ci.seattle.wa.us> wrote:
>
> >The problem, most likely, is that you come from a SQL Server background. There
> >is almost no need, I'd say no excuse, for temporary tables in Oracle.
>
> But sometimes they come in handy: we have an app with row level
> privileges. The rules behind the privileges are quirky and clumpsy,
> but that's the way the customer wanted it to be. Determining the
> privileges for each row again and again would be a real performance
> hog. Now we evaluate the privileges on application startup and store
> them in a global temporary table. No more problem!
>
> regards
> Marc Blum
> mailto:marc_at_marcblum.de
> http://www.marcblum.de
Received on Tue Feb 12 2002 - 15:07:15 CST