Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: create table/index priviledge

Re: create table/index priviledge

From: <samikn27_at_my-deja.com>
Date: Wed, 29 Nov 2000 02:00:38 GMT
Message-ID: <901o03$sfp$1@nnrp1.deja.com>

create user u1,
grant connect to u1;
alter user u1 quota 50K on tablespace ts1; Create table u1.t1...

u1 will own the table but u1 can not creat ethe table...

In article <8vva5d$tmq$1_at_nnrp1.deja.com>,   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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 28 2000 - 20:00:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US