What to GRANT a developing user ?

I am new at this, so if this is a stupid question please forgive me.

I have created a user 'test' and given him permissions to create a session and create a table. Now when the user logs in he tries to create a table and gets the following error :

SQL> create table test (name char(2), id number); create table test (name char(2), id number) *
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSTEM'

Apparently he is logging into to the wrong tablespace. Maybe I need to create a seperate tablespace for him and modify the login script so that Oracle logs him in his own tablespace and not the system where he is free to do what he wants with that tablespace.

Is this the right solution to the problem ? Also are there any other permissions that I need to give him besides "create table" and "create session" ? He is going to be a developing user and making alot of mistakes so I we want him to stay in a limited space and do whatever damage they want to do to their own tablespace.

Thanks very much !

Atif Khan
aak2_at_ra.msstate.edu Received on Mon Nov 04 1996 - 00:00:00 CST