Have you tried to grant unlimited tablespace at the users ?
Bye
Nandakumar ha scritto nel messaggio <80icpl$klo$1_at_nnrp1.deja.com>...
>Hi
>
>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 Sat Nov 13 1999 - 04:05:25 CST
