From: "Spencer" <spencerp@swbell.net>
Newsgroups: comp.databases.oracle.server
References: <3B1E9D5D.83CE8E04@xs4all.nl> <kd4thtc42vqrsj518ojnsvl81rc5nuc2ac@4ax.com>
Subject: Re: new user & tablespace
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <d3BT6.189$z14.122156@nnrp3.sbc.net>
Date: Wed, 6 Jun 2001 20:50:09 -0500
NNTP-Posting-Host: 208.190.209.137
X-Complaints-To: abuse@swbell.net
X-Trace: nnrp3.sbc.net 991878473 208.190.209.137 (Wed, 06 Jun 2001 20:47:53 CDT)
NNTP-Posting-Date: Wed, 06 Jun 2001 20:47:53 CDT
Organization: SBC Internet Services


-or-

ALTER USER <username> QUOTA UNLIMITED ON <tablespacename> ;

note: grant RESOURCE role also grants UMLIMITED TABLESPACE
system privilege, which means user will have umlimited quota on all
tablespaces, including SYSTEM.  also, user will be able to specify
initial and next extent sizes without regard to the MINIMUM EXTENT
specified for the tablespace.  (for 8.0.6, at least.  things may have
changed in 8.1.x).


"TurkBear" <noone@nowhere.com> wrote in message
news:kd4thtc42vqrsj518ojnsvl81rc5nuc2ac@4ax.com...
> Be sure the user is granted RESOURCE  in addition to connect
>
> Also, be sure there is no quota imposed on the tablespace desired...
>
> (BTW, Never create anything in the system tablespace - let Oracle use it
 for its
> stuff, but keep users out)
>
>
> Henk Jan Barendregt <hjb@xs4all.nl> wrote:
>
> >Hi,
> >
> >Any new user i create isn't allowed to create tables
> >in the system or users tablespace. Although the user
> >is granted to create tables and views.
> >oracle returns the message :
> >
> >ORA-01950: no privileges on tablespace 'TABLESPACE'
> >
> >How can i allow user to access a tablespace to create
> >tables ?
> >
> >Regards,
> >
> >Henk Jan
>
>