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?
