Re: user cant create tables!!

In article <6pq4e1$pog$1_at_talia.mad.ibernet.es>, Jorge <jorge_at_workflow.es> 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?

Hi,

Have you tried the following:

ALTER USER wcin_usuario QUOTA 100K ON wcin_datos;

(replace 100K by the amount of space you really want to grant)

You might also have to assign a temporary tablespace to the user, and give him/her a quota on it as well.

Chris

--

Chris L. Mason           For UNIX software ratings and reviews as
cmason_at_unixzone.com      well as industry news and opinions visit

                         UnixZone:       http://www.unixzone.com/

-----------------------------------------------------------------