current user

jisuprusty

New Member

Join Date: Mar 2008

Posts: 7
#1

current user

Mar 28 '08, 01:04 PM

is it possible to show who is the current user with out using the command show user?????
Tags: None
amitpatel66

Recognized Expert Top Contributor

Join Date: Mar 2007

Posts: 2358
#2

Mar 28 '08, 01:27 PM

Originally posted by jisuprusty

is it possible to show who is the current user with out using the command show user?????

[code=oracle]

SQL> select user from dual;

USER
------------------------------
APPS

SQL> select user_name from v$session WHERE OSUSER = <your operating system Login>

[/code]
Comment

Comment