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.
|
|
|