Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> new user & tablespace

new user & tablespace

From: Henk Jan Barendregt <hjb_at_xs4all.nl>
Date: Wed, 06 Jun 2001 22:15:09 +0100
Message-ID: <3B1E9D5D.83CE8E04@xs4all.nl>

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 Received on Wed Jun 06 2001 - 16:15:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US