-
If there are no rows in the dba_ts_quotas table, does that mean that every user has unlimited tablespace space priviledges?
-
Yes. Such users will not have any rows in DBA_TS_QUOTAS.
-
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|