dba_ts_quota question

[lesstjm]

If there are no rows in the dba_ts_quotas table, does that mean that every user has unlimited tablespace space priviledges?

[julian]

Yes. Such users will not have any rows in DBA_TS_QUOTAS.

[lesstjm]

thanks a lot.

[amar]

For an entry to appear in DBA_TS_QUOTAS, you have to execute the ALTER USER < username > QUOTA ..... ON < ts > command.

Users who appear in the DBA_TS_QUOTAS view may have UNLIMITED space quota on a tablespace, if defined as follows:

ALTER USER < user > QUOTA UNLIMITED ON < ts > ;

The UNLIMITED quota will be indicated by "-1" in the MAX fields.

-amar