查询oracle所有用户的sql语句？

Question

查询oracle所有用户的sql语句？

Answer 1

select * from dba_users;

Answer 2

参考这三个
SELECT * FROM user_users;
SELECT * FROM all_users;
SELECT * FROM dba_users;

Answer 3

 查询表和字段可以用user_col_comments 

Answer 4

关键是在什么权限下查询用户
select *　from dba_users;

Answer 5

select * from all_col_comments
select * from dba_col_comments
select * from user_col_comments
select * from all_tables
select * from user_tables
select * from dba_tables
select * from all_views
select * from user_views
select * from dba_views

Answer 6

查看当前用户，
show user;