Re: create temporary table privs

Jared wrote:

> 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

Dynamic temporary tables are an idea born of problems and are best not used for anything in Oracle. And in Oracle there is really nothing that is a true temporary table though the global temporary tables come close they are truly permanent tables.

Here's what I'd do if firing the developer was not an option ... or at least a plausible threat.

1. ALTER USER <user_name> QUOTA 64K ON tablespace_name;

   Or some other reasonably small value.

2. Explore the Oracle 8i system triggers and write a BEFORE LOGOFF trigger that drops every object, or table, in DBA_OBJECTS, or DBA_TABLES, owned by this developer.

I still advocate having someone in management with hiring-firing responsibility walk the person out to their car and explaining to them, in clear and precise terms, that the next time they violate procedures they won't be coming back in. There are plenty of responsible developers looking for work. You should not have to put up with a lack of professional discipline.

Daniel Morgan Received on Tue Jun 11 2002 - 17:05:13 CDT