Re: new user & tablespace

Incidentally, I see that some are recommending granting 'resource to fred'. Don't. In Oracle 7, you'd usually create a user and then 'grant connect, resource to fred'. Trouble is, resource implies unlimited quota on everything.

In Oracle 8, the recommended approach is to 'grant create session to fred', which allows fred to issue a connect string -but implies *no* quota on anything, so all quota grants must be explicit. Much safer.

Regards
HJR

--
=============================!!=============================
The views expressed are my own only, and definitely NOT those of Oracle
Corporation
=============================!!=============================


"Henk Jan Barendregt" <hjb_at_xs4all.nl> wrote in message
news:3B1E9D5D.83CE8E04_at_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