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: Fri Dec 09 07:40:47 CST 2016

Total time taken to generate the page: 0.19829 seconds