Re: Question on grant privilege

Hi Sybrand Bakker,

        My problem is I have a user, let say "user01". His default tablespace is users01 but when he create a table, the error message prompt about "no permission / privilege" to create table. I have grant "create any table" privilege to him but still fail, how can i do this?

Best Regards,
Henry

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> ???????:a20d28ee.0111122347.1474e3f8_at_posting.google.com...
> "abc" <efg_at_abc.com> wrote in message
 news:<9sm6qd$l9q1_at_imsp212.netvigator.com>...
> > Dear all,
> >
> > I want to grant the "create table" rights to user "users01"
 on
> > specific tablespace, how can I do it? Thanks.
>
> This is not implemented by the create table privilege.
> Oracle has implemented quota for that purpose.
> You need to
> revoke unlimited tablespace from users01 (otherwise he can still
> create objects everywhere
> and
> alter user users01 quota <number>|unlimited on <tablespace>
>
> Hth
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Tue Nov 13 2001 - 16:37:29 CET