Re: Revoking privilege to create global temporary tables?

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3D9477B3.C19F6033_at_exesolutions.com>...
> I can not think of any way to specifically inhibit someone from creating
> a GTT. Though in the same breath I think it 99% likely that the people
> you are concerned about don't even know they exist or how to create
> them.

In my application, a global temporary table is created automatically to create a temporary 'join table' when I write data to Oracle, so the user doesn't have to be aware of the existence or use of global temporary tables. My application handles everything for him.

I finally found out that a simple revoke of the create table privilege also
prohibits a user from creating global temporary tables. The only thing was that the user I tried this on, inherited the create table privilege through a certain role that wasn't immediately clear to me.  

> But I fail to see how having a GTT in a schema could possibly affect any
> "special mode".

When the user that connects to Oracle through my application doesn't have rights to create global temporary tables, another - slower - mode (the mysterious 'special mode':-)) is used to write the data to Oracle. I just wanted to be able to test this special mode.

Mischa Received on Tue Oct 01 2002 - 09:25:24 CDT