得到表空间上有几个用户

Question

我想select到某个表空间上有几个用户,用sql语句如何得到啊!

Answer 1

例如查询表空间为users上所有的user可以用下述方法
select * from user_users where lower(default_tablespace)='users'

Answer 2

select username from dba_users where default_tablespace='AAAA';

Answer 3

是这样吗？SQL> select a.tablespace_name,b.username from dba_tablespaces a
  2  inner join dba_users b on a.tablespace_name = b.default_tablespace;TABLESPACE_NAME                USERNAME
------------------------------ ------------------------------
SYSTEM                         SYS
SYSTEM                         SYSTEM
SYSTEM                         DBSNMP
SYSTEM                         SCOTT
DRSYS                          CTXSYS
SYSTEM                         ECOPADMIN
SYSTEM                         ECOPCONNECT
SYSTEM                         TESTINTERMEDIA
SYSTEM                         TEST
CATALOG_TS                     CATALOG
RMAN_TS                        RMAN1
SYSTEM                         ECOPEVENT
SYSTEM                         ECOPCONSOLE
PERFSTAT                       PERFSTAT
SYSTEM                         OUTLN
XDB                            XDB
DRSYS                          WKSYS
ODM                            ODM
CWMLITE                        OLAPSYSTABLESPACE_NAME                USERNAME
------------------------------ ------------------------------
EXAMPLE                        QS_ES
EXAMPLE                        QS_WS
EXAMPLE                        QS
EXAMPLE                        QS_ADM
EXAMPLE                        SH
EXAMPLE                        PM
EXAMPLE                        OE
EXAMPLE                        HR
TOOLS                          RMAN