Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01950: no privileges on tablespace
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