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

From: (wrong string) ønlien <jgronli_at_sn.no>
Date: 1996/04/16
Message-ID: <31740C3B.551C_at_sn.no>#1/1


MCC 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.

You have to give john quota on the tablespace !!!

alter user john quota unlimited on tablespace users;

or change unlimited to an nice value.... Should fix it. Received on Tue Apr 16 1996 - 00:00:00 CEST

Original text of this message