quota

[mary]

How do I find out what quota my users have? Which dba_view do I query?
thank you.

[sreddy]

DBA_TS_QUOTAS

[mary]

I just noticed I have multiple users in my database. When I queried dba_ts_quotas there is only one row retrieved. So, there is no such thing as 'dfault quota' assigned when a users is created. You as a dba have to assign quota. Only after that you'll see a record in dba_ts_quotas. For some reason I thought there would be a records per each tablespace per each user.

[jmodic]

Might be that all of your users are created with UNLIMITED TABLESPACE system privilege, meaning that they all have unlimited quota on each and every tablespace in the system. It is either that or only one of your users is able to create tables and indexes on the whole system....

[mary]

So, if they all have unlimited quota they would not be recorded in the dba_ts_quotas view? How strange...
Even if it would be one user only the user I see in the dba_ts_quotas is not the one which is most used by number of users in my db.
But thank you anyway. I don't mean to question Jurij's answer I am still working on understanding it fully.

[jmodic]

I guess they (at Oracle corp.) just decided not to record the same information twice. If somone has UNLIMITED TABLESPACE system privilege, it is recorded in DBA_SYS_PRIVS (well, in underlying table actually), so there is realy no need to store that information on DBA_TS_QUOTAS.

It is very simmilar situation as if a user has SELECT ANY TABLE sys privilege and you would expect to find this user listed with select privilege in DBA_TAB_PRIVS listed for each and every table in the database.

HTH,