Re: user cant create tables!!

Hi Jorge,
You only missed one tiny thing.
either
grant unlimited tablespace to <user> (which is of course not recommended, as this user will be able to create tables everywhere or
alter user <username> quota bytes|unlimited on tablespace <tablespace_name> This way is recommended.
There are datadictionary views (dba_ts_quotas, user_ts_quotas) to see how much he has already consumed.
May I advise against pctincrease 50 in the default storage clause of the tablespace. Quite frequently this results in tablespace fragmentation as every next extent of a table segment is getting bigger and bigger.

Hth,
Sybrand Bakker
(postbus_at_sybrandb.demon.nl)

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 Sat Aug 08 1998 - 04:25:28 CDT