Re: create table/index priviledge

In article <904d51$20u$1_at_nnrp1.deja.com>,   gzwzhang_at_my-deja.com wrote:
> 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?

how about the 'connect' role? the connec role too grants the user the basics CREATE commands privileges.

HTH, :) ATTA  
>
> 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.
>

--

getting the meanin' of data...


Sent via Deja.com http://www.deja.com/
Before you buy.