当前用户:

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;