Re: create temporary table privs

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 11 Jun 2002 21:00:42 +0100
Message-ID: <1023825635.14403.1.nnrp-13.9e984b29@news.demon.co.uk>

How about granting CREATE TABLE, but
not giving him a quota on any tablespace.

All CREATE TABLE statements should
fail, but CREATE TEMPORARY TABLE
doesn't demand space, so it may succeed.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
        UK            June / July
        Australia      July / August
http://www.jlcomp.demon.co.uk/seminar.html

Jared wrote in message <480f610.0206111153.4682ea56_at_posting.google.com>...


>Under 8.1.7.2, does anyone know a way to allow a schema to create

>temporary tables but not permanent?  I have a developer abusing his

>privileges and want to make sure there's nothing else I can do before

>taking 'create table' away from him and defending my actions to our

>manager.

>

>TIA -

>

>Regards,

>jh

Received on Tue Jun 11 2002 - 15:00:42 CDT