Re: Question: seting tablespace priv for user

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/10/23
Message-ID: <344ef044.6685883@netnews.worldnet.att.net>#1/1

Try this:

ALTER USER user_name QUOTA UNLIMITED ON usr;

Instead of UNLIMITED, you could give that user a tablespace quota of 100MB, or any other number of MB (or KB) you feel appropriate for the database objects the user is going to create in the USR tablespace.

Hope this helps.

Michael Serbanescu

---

On 22 Oct 1997 21:21:50 GMT, "Haresh Assumal" <assumal_at_sprynet.com> wrote:

>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 Thu Oct 23 1997 - 00:00:00 CDT