Re: user cant create tables!!

Jorge,

    I'm not sure, but I believe you need to define a quota for the tablespace before the user can allocate space there for a table. Try this:

alter user wcin_usuario quota unlimited on wcin_datos (you may want to specify the size (in K or M) instead of unlimited)

Jorge wrote:

> 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 Thu Jul 30 1998 - 11:45:05 CDT