Re: Create Tablespaces

"Rob Zwartjes" <rzwartje_at_rob.home.nl> wrote in message news:slrn8l4r9j.8eo.rzwartje_at_rob.home.nl...
> On Wed, 21 Jun 2000 18:10:40 GMT, schmidm_at_kta95.com <schmidm_at_kta95.com>
 wrote:
> >I have created a tablespace using the system account. i have created a
> >user. I want the user to be able to create tables in the tablespace,
> >but I keep getting the error ORA-01950 - no privileges on
> >tablesapce '<name>'. I granted DBA priveleges to this user, but I
> >still get this error.
> I am also a beginner and ran into the some problem. After searching
 through a
> lot of pdf docu. I found out that you can give the user a default
 tablespace
> name. It goes like this :
> create user .... ( this part you already have done )
> default tablespace < your created tablespace name >
> temporary tablespace temp;
>
> grant connect, resource to <user>;
>
> I hope this will help you.
> Maybe the guru's here disagree with me :) If so, I will read there
 comments
> thoroughly and learn from it.

No disagreements here. This is pretty usual. The only exception might be if you wish to allocate quotas to different userswho all have the same default tablespace - this stops them eating all the space up. Received on Fri Jun 23 2000 - 00:00:00 CDT