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

  • From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
  • To: shastry17@xxxxxxxxx
  • Date: Thu, 26 Jul 2007 16:09:41 -0500

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

Other related posts: