To Retrieve Username

[jaihere]

To get the current connected username of the oracle user. Is there any system table having the required details to retrieve the username. I want to display the username in Oracle Reports.

[Paul Campbell]

you're in the wrong forum... but v$session has that information.

[Paul Campbell]

I just reread your post... in Oracle reports you should just capture the authenticated user... there isn't a need for you to go to v$session... how does the user launch the report?

[Campbell Ritchie]

"jaihere" please read the important administrative private message I sent a minute ago.

CR
[ October 07, 2008: Message edited by: Campbell Ritchie ]