Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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.comReceived on Tue Nov 12 1996 - 00:00:00 CST
![]() |
![]() |