Redian新闻
>
how to know how many uses exists in my db?
avatar
how to know how many uses exists in my db?# Database - 数据库
A*g
1
my oracle database messed up,
can anyone tell me how to use
sql to find out how many users
in my db? and what are their
default database? login as system/manager.
thanx!!!
avatar
p*s
2

select username from all_users;
offers you all user's names
apply count() aggregate will tell you how many they are
select username, default_tablespace from user_users
offers you default tablespace associated with a normal user
select username, default_tablespace from dba_users;
is similar to the above, but tells you same thing about those
dbas

【在 A***g 的大作中提到】
: my oracle database messed up,
: can anyone tell me how to use
: sql to find out how many users
: in my db? and what are their
: default database? login as system/manager.
: thanx!!!

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。