• Post Reply Bookmark Topic Watch Topic
  • New Topic

To Retrieve Username  RSS feed

 
jaihere
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you're in the wrong forum... but v$session has that information.
 
Paul Campbell
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Marshal
Posts: 56570
172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"jaihere" please read the important administrative private message I sent a minute ago.

CR
[ October 07, 2008: Message edited by: Campbell Ritchie ]
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!