Re: Need help in finding the usernames which belong to particular tablspace

Anant,

What are you trying to determine? The users who have objects stored in that tablespace?

select distinct owner from dba_tables where tablespace_name = '<TS_NAME>';

Also check for indexes and other physical object types your database contains.

Or users who have permission to create objects in that tablespace?

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l