Re: create table/index priviledge

From: <gzwzhang_at_my-deja.com>
Date: Thu, 30 Nov 2000 02:13:56 GMT
Message-ID: <904d51$20u$1@nnrp1.deja.com>

Hi Sybrand,

revoke create table from that user doesn't work. I have checked that user doesn't have the resource role. What's the purpose of creating this command?

Thanks,
Winston

In article <900drb$5ub8o$3_at_ID-62141.news.dfncis.de>, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
>
> <gzwzhang_at_my-deja.com> wrote in message
news:8vva5d$tmq$1_at_nnrp1.deja.com...
> > 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.
>
> revoke create table from <user>.
> If you don't have manuals they are available online at
> http://technet.oracle.com
> There's no separate create index privilege on user level.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 29 2000 - 20:13:56 CST