Home » Developer & Programmer » Application Express & MOD_PLSQL » Retrieve user ID from the current Oracle session (Apex 10g)
Retrieve user ID from the current Oracle session [message #329984] Fri, 27 June 2008 03:31 Go to next message
matej.kovacik
Messages: 1
Registered: June 2008
Junior Member
Hello,

I need to assign username from the current user to the text field in the project. I use the function "user" but all times it gives me back value "ANONYMOUS". We are small callcentrum and our telephonists fill-in the information in projects. It would be fine if I could see, how much records have done each of the telephonists. So I added text field telephonist to the project and want to autofill this field using function user.
(http://www.techonthenet.com/oracle/functions/username.php)
Each of the telephonists log into the project using his own username and password and I dont know, why this function gives me back value ANONYMOUS.

I am not familiar with apex yet, by the way, so please if you could help me...I would be grateful.
Re: Retrieve user ID from the current Oracle session [message #330193 is a reply to message #329984] Fri, 27 June 2008 19:00 Go to previous message
andrew again
Messages: 2574
Registered: March 2000
Senior Member
"user" is a pseudo column just like sysdate. The Apex variable holding the Apex user name used during Apex login is APP_USER.

http://forums.oracle.com/forums/thread.jspa?messageID=2238515&#2238515
Previous Topic: pass a cookie from one dad to another
Next Topic: authentication required window pl/sql
Goto Forum:
  


Current Time: Wed Jul 30 05:02:39 CDT 2014

Total time taken to generate the page: 0.08730 seconds