Re: How to create a table in another user

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sun, 20 Jun 1999 04:19:11 GMT
Message-ID: <37736225.45768391@netnews.worldnet.att.net>

On Fri, 18 Jun 1999 11:39:29 -0500, "Benny Yazdanpanahi" <biyazdanpanahi_at_marathonoil.com> wrote:

>I have an sql which i am running from user1 ( e.g.)
>
>and in that SQL i am trying to create a temporary table in another user
> e.g. user2 )

Is it possible to avoid having user2 own the temp table? Maybe user1 could own it instead. Then you eliminate the entire issue. How are you using the temp table?

Jonathan Received on Sat Jun 19 1999 - 23:19:11 CDT