Re: What to GRANT a developing user ?

Lun Wing San (Oracle) wrote:
> ALTER USER username DEFAULT TABLESPACE data_ts QUOTA nnn ON data_ts.
>
> It is highly recommend to do in this way.
>
> Alternatively,
>
> You can create tables in another tablespace besides the default one, SYSTEM.
>
> CREATE TABLE tablename ( ... ) TABLESPACE data_ts.
>
> It is more recommended to set a quota on each tablespace so that the DBA can be easier
> to manage the resource and predict the size of each tablespace, hence the size of
> datafiles.

Is it possible to establish default quota for a role so that when creating users they automatically get their quotas set when they are assigned a role?

--
Mike Linksvayer   ml_at_justintime.com