Getting current Username 1

[AndreasAuer]

Is it possible to get the current loginname with SQL? Its not important, if its the Windows-Loginname or the loginname of Oracle.
It would be nice if it would be possible.

 

[Kenrae]

Yes, the sentence is:

SELECT user FROM dual;

That's Oracle username.

 

[carp]

Or SELECT username FROM USER_USERS;

 

[tmutsambwa]

The easiest way if you go to the Oracle SQL prompt is to type "SHOW USER" without the quotes.