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 <[EMAIL PROTECTED]> 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? >
