db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "adam jvok" <ajv...@gmail.com>
Subject Temp Tables: User can not perform the operation in schema 'SESSION'.
Date Thu, 06 Dec 2007 04:39:37 GMT
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