当前用户:
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;

oracle sql