From: Henk Jan Barendregt <hjb@xs4all.nl>
Newsgroups: comp.databases.oracle.server
Subject: new user & tablespace
Date: Wed, 06 Jun 2001 22:15:09 +0100
Organization: XS4ALL Internet BV
Lines: 15
Message-ID: <3B1E9D5D.83CE8E04@xs4all.nl>
NNTP-Posting-Host: barendregt.xs4all.nl
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news1.xs4all.nl 991858514 19458 194.109.56.73 (6 Jun 2001 20:15:14 GMT)
X-Complaints-To: abuse@xs4all.nl
NNTP-Posting-Date: 6 Jun 2001 20:15:14 GMT
X-Mailer: Mozilla 4.7 [en] (X11; I; SunOS 5.8 sun4m)
X-Accept-Language: nl, en


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