Re: ORA-01950: no privileges on tablespace

From: Ben Ryan <benryan_at_my-deja.com>
Date: Sat, 13 Nov 1999 03:36:59 GMT
Message-ID: <80imcr$r3a$1@nnrp1.deja.com>

In article <80icpl$klo$1_at_nnrp1.deja.com>, Nandakumar <N.Kumar_at_rocketmail.com> wrote:
> i created two tablespaces ts1,ts2 and a user user_a.
> user_a has ts1 as temporary tablespace and ts2 as default tablespace.
> user_a has connect/resource/'create session' privileges granted thru'
a
> role ( of abovementioned three privs).
> And now ... when user_a attempts to create a table the foll. error
pops
> up.
> create table t_test ( n1 number )
> *
> ERROR at line 1:
> ORA-01950: no privileges on tablespace 'ts2'
>
> coud anyone suggest what i'm doing wrong?
> ... should i have to grant resource privelege 'explicitly' (... not
> using a role )??

When you use CREATE USER (or ALTER USER) you need to add a QUOTA statement. e.g.

CREATE USER user_a IDENTIFIED BY whatever

   TEMPORARY TABLESPACE ts1
   DEFAULT TABLESPACE ts2
   QUOTA UNLIMITED ON ts2;

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 12 1999 - 21:36:59 CST