Re: Question: seting tablespace priv for user

Haresh:

You need to grant the user a quota on the tablespace. This is handled on a per user basis with the following comand:

   alter user Fred

      quota unlimited on USR;

You can exchange unlimited with any size.

Roy Klassen rklassen_at_pei.sympatico.ca

Haresh Assumal <assumal_at_sprynet.com> wrote in article <01bcdf34$20c36120$fab1aacc_at_mycomp.intermediainc.com>...
> Could someone please tell me how to set tablespace privileges for a user?
 I
> created a database then created a user (who's default tablespace is set
 to
> USR). When the user tried to create a table the follow error occurs:
>
> ORA-01950: no privileges on tablespace 'USR'
>
> My question is how do I resolve this. Does this need to be handle on a
 per
> user bases or just once when I create the tablespace USR.
>
> Thanks for your help,
>
> Haresh
> E-mail: assumal_at_sprynet.com
>
Received on Sat Oct 25 1997 - 00:00:00 CDT