Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: create table/index priviledge
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