Find out users quota for tablespaces

Category : Home > Databases > Oracle > Security

Query dba_ts_quotas to see users' quota per tablespace

select tablespace_name 
from dba_ts_quotas 
where username = 'USERNAME'
/

Options


Start discussion or add comment to this tip

Details

Tip reference : #60 views : 527	Added on : 12/01/05	Submited by : h8dk97

Send a message	Printer friendly output Display this member's tips (149)


<< Previous

	Most viewed tips
	Databases > Oracle > Security : How to unlock Oracle user account
	Databases > Oracle > Performance Tuning : How to enable trace in Oracle
	Databases > Oracle : Kill user session
	Databases > Oracle : Scripts to backup Oracle database on Windows NT

	All categories Databases \| Programming \| Hardware \| Operating Systems \| Networking \| Internet \| ERP / CRM \| Games & Multimedia \| Graphics & Design \| Miscellaneous \| Office Software \| TipLib FAQ