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

Home -> Community -> Usenet -> c.d.o.misc -> Re: What to GRANT a developing user ?

Re: What to GRANT a developing user ?

From: Peter Rak <po080016_at_pop.ke.sanet.sk>
Date: 1996/11/05
Message-ID: <327EDADF.24D8@pop.ke.sanet.sk>#1/1

Hi,

You need to create another tablespace and then grant access to this tablespace.
Do this:
create tablespace test_ts ...
alter user test default tablespace test_ts quota unlimited (or some size) on test_ts;

                Peter.

Atif Ahmad Khan wrote:
>
> 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 Tue Nov 05 1996 - 00:00:00 CST

Original text of this message

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