Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |