From: TurkBear <noone@nowhere.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: new user & tablespace
Date: Wed, 06 Jun 2001 15:27:42 -0500
Reply-To: See Message body for real address
Message-ID: <kd4thtc42vqrsj518ojnsvl81rc5nuc2ac@4ax.com>
References: <3B1E9D5D.83CE8E04@xs4all.nl>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 26
X-Authenticated-User: turkbear
X-Comments: This message was posted through Spamkiller.Newsfeeds.com
X-Comments2: IMPORTANT: Newsfeeds.com does not condone, nor support,  spam or any illegal or copyrighted postings.
X-Comments3: IMPORTANT: Under NO circumstances will postings containing illegal or copyrighted material through this service be tolerated!!
X-Report: Please report illegal or inappropriate use to <abuse@newsfeeds.com> You may also use our online abuse reporting from: http://www.newsfeeds.com/abuseform.htm
X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body (DO NOT SEND ATTACHMENTS)
Organization: Newsfeeds.com http://www.newsfeeds.com 73,000+ UNCENSORED Newsgroups.


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