Re: HELP!! can not create table ...

Did you 'grant resource' when you created the user rather than 'grant connect' You need resource or dba to create objects.

HTH MCC (duffy_at_cais.cais.com) wrote:
: I am a new DBA, I create a user "john" on the default tablespace "users".
: I grant the "create session, create table" priviliege to john. I use
: 'select * from user_sys_privs" confirm "john" have "create session and
: create table". John tried to create a table "create table junk (j
: number);" and has error message "ora-01950: no privileges on tablespace
: 'users'". Can anyone tell me why? Thank you for help.
Received on Tue Apr 16 1996 - 00:00:00 CEST