Re: Revoking privilege to create global temporary tables?

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 27 Sep 2002 15:22:43 GMT
Message-ID: <3D9477B3.C19F6033@exesolutions.com>

mischab wrote:

> Hi,
>
> I'm looking for a possibility to be able to exclude a user from
> creating global temporary tables in Oracle 8i. I need this, in order
> to be able to test a special mode in my program that uses Oracle.
>
> Is there such a possibility?
>
> Thanks in advance,
> Mischa

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.

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

The only thing I can think of, and I haven't tried it to see if it works, would be an AFTER CREATE DDL trigger that would examine the object's properties and destroy it if it is a GTT.

Daniel Morgan Received on Fri Sep 27 2002 - 10:22:43 CDT