当前用户:
select * from user_users;
select user from dual;
show user
查看当前那些用户登录:
select username,serial#, sid from v$session;
select username,privilege from user_sys_privs;
select * from all_users;
原文：http://www.cnblogs.com/ruiy/p/7186809.html