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