Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: new user & tablespace
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_at_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
Received on Wed Jun 06 2001 - 15:27:42 CDT