Re: privileges on tablespace

Jean-Paul Le Fevre wrote:
>
> A newbie question :
>
> I've just installed Oracle on my Linux box.
> I've granted right to create table to user Joe.
> However Joe is still unable to create his table since
> he has no privileges on tablespace.
>
> Which tablespace should he use ?
> How to give him privilege to modify the tablespace ?
>
> Thank you,
>
> --
> ____________________________________________________________________________
>
> Jean-Paul Le Fèvre * CEA Saclay DAPNIA/SEI * Mail : Jean-Paul.LeFevre_at_cea.fr

They will need a quota...

eg

alter user XXX quota 100M on MY_TABLESPACE;

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"