db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta Satoor" <msat...@gmail.com>
Subject Re: Temp Tables: User can not perform the operation in schema 'SESSION'.
Date Thu, 06 Dec 2007 05:41:59 GMT
Adam, can you provide simple ij script or sequence of sql statements
to demonstrate the problem. That will make it easier for people to see
exactly what is going on.

Mamta

On 12/5/07, adam jvok <ajvok1@gmail.com> wrote:
> I can create a temp table with no problem like this:
>
>   declare global temporary table t1(a int) on commit preserve rows not logged;
>
> ONLY if I am connected using the username that created the db.
>
> Attempting to create a temp table as any other user results in:
>
>   User 'whatever' can not perform the operation in schema 'SESSION'.
>
> Is it possible to overcome this?
>

Mime
View raw message