ORA-01950: no privileges on tablespace

From: Nandakumar <N.Kumar_at_rocketmail.com>
Date: Sat, 13 Nov 1999 00:53:10 GMT
Message-ID: <80icpl$klo$1@nnrp1.deja.com>

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 )??

Thanks & regards
Nanda

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 12 1999 - 18:53:10 CST