What to GRANT a developing user ?
Date: 1996/11/04
Message-ID: <aak2.847163766_at_Isis.MsState.Edu>#1/1
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)
*
Apparently he is logging into to the wrong 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 !
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSTEM'
Atif Khan
aak2_at_ra.msstate.edu
Received on Mon Nov 04 1996 - 00:00:00 CET