How to get client machine name from database ?
9189Sep 4 2008 — edited Oct 7 2008Hiya
As part of the user authentication in our application, the requirement is that if a user has logged in from one machine, the same user cannnot login from different machine at the same time.
In Forms6i, we had accomplished this using the following query:
Select Terminal
From v$session
Where username = v_username
And terminal <> v_terminal;
Where
v_username = USER -> Oracle Forms Reserve Word
v_terminal = Client_Win_API_Environment.Get_Windows_Username
In Forms 6i, the Terminal column of V$Session used to return the name of the local client machine.
However, in Forms 10g, it returns the machine name on which Oracle Application Server is installed, which I believe is correct.
So my question is how do we get the client machine name from database in the context of Oracle Forms 10g ? Is there another view/table or database package that returns the client machine name ?
Your suggestions/comments will be much appreciated.
Cheers
Mayur