Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Question: seting tablespace priv for user
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