Re: create table/index priviledge

From: deana strbevski <deana.strbevski_at_ina.hr>
Date: Tue, 28 Nov 2000 15:50:21 +0100
Message-ID: <3A23C62D.363C0A1D@ina.hr>

You should create another schema for user, in user schema create synonyms and as DBA user grant him privileges select,insert,update,delete on the tables.

gzwzhang_at_my-deja.com wrote:

> HOw to revoke 'create table' and 'create index' priviledge from a user?
> That user can own the tables, indexes, but those table/indexes must be
> created by DBA for him.
>
> Any idea will be appreciated?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 28 2000 - 08:50:21 CST