Re: HELP!! can not create table ...
From: <pdchris_at_ibm.net>
Date: 1996/04/23
Message-ID: <4lhid1$3r4q_at_news-s01.ny.us.ibm.net>#1/1
Date: 1996/04/23
Message-ID: <4lhid1$3r4q_at_news-s01.ny.us.ibm.net>#1/1
In <4l0sr8$59c_at_news2.cais.com>, duffy_at_cais.cais.com (MCC) writes:
>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.
Did you provide a quota on user for john? If not, he has no room to create anything Received on Tue Apr 23 1996 - 00:00:00 CEST