Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Getting Username
Getting Username [message #184786] Fri, 28 July 2006 00:53
hansraj_sharma
Messages: 1
Registered: July 2006
Junior Member
In Oracle 10g Xe Application Builder & SQL Commands Screen when I execute
select user,userenv('TERMINAL') from dual
I am getting username as 'ANONYMOUS' and NULL for Terminal Name irrespective of whichever user do I connect to Database whereas the same query provides correct response when executed through SQL command Line mode.
If someone can tell me Why it is happening & how to get actual username & system name.

Previous Topic: AJAX and screen flicker
Next Topic: DBMS_JOB for parallel processing
Goto Forum:
  


Current Time: Thu Mar 28 08:37:27 CDT 2024