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
