user cant create tables!!

Hi, when a user tries to create a table

    ex:
    create table one ( id char(1));

Oracle returns this error:

ORA-01950: no privileges on tablespace "name"

Cause: The attempt to give the user a tablespace quota failed because the user does not have the necessary system privileges.

Action: Either grant the user the system privileges needed to create objects in the specified tablespace or grant the user a specific space resource in the tablespace.

I created the user this way

        create user wcin_usuario identified by wcin_admin;

        alter user wcin_usuario default tablespace wcin_datos

        create role wcin_usuario_role;

        grant connect, resource to wcin_usuario_role;

        grant wcin_usuario_role to wcin_usuario;

And this tablespace: (before creating user, of course)

    create tablespace wcin_datos datafile 'd:\oradata\wcin\database\wcin1wcin.ora' size 10M reuse autoextend on next 100k default storage ( initial 100K next 100K minextents 1 maxextents unlimited pctincrease 50 );

What's happening? what did I forget?
Can anybody help me?
Thanks and please send me a mail to jorge_at_workflow.es Received on Mon Jul 27 1998 - 10:45:27 CDT