Re: Question: seting tablespace priv for user

You can do one of the following :

1. Use "alter user <username> quota ..." for the user.
2. Grant unlimited tablespace privilege to the user, which allows the user access to any tablespace.
3. Grant resource privilege to the user, which automatically gives unlimited access for the user, on all tablespaces. (Maybe, you do not want to do this because there are other privileges such as "create procedure" .. that come with it.

Krish

Haresh Assumal wrote in message
<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 Wed Oct 22 1997 - 00:00:00 CDT