To be honest, I think the computer name would be of sufficient, but this is something I must discuss with my team member and leader, hopefully this will be enough, it just somewhat surprises me that Oracle have no way of retrieving the IP information.
Again I thank you Mike for replying me...
To say it in the simplistic way is that my application will have a table of applications (whether it be a oracle web app, an asp app, or vb client/server app) that will use my current application to authenticate their own application's user, the reason is that I work for the government, so the...
thanks Mike for you paying attention to my posting and replying numerous times, then thing right now is that my application will be a central place for other group's application to authenticate their users, I will have to provide oracle procedure to validate their requests in numerous possible...
The machines that will be authenticated will only be the server machines, and they will not be using DHCP, so the IP address will not change, your suggestion of calling Windows API method is intriguing, can that be done through Oracle, or is that what you really meant?
Thankyou for replying, I have tried the method to selecting from the v$session table and search for the machine field, but it seems that it is not returning the IP address that I initially needed just the computer name, can anyone verify that for me?
Hi Mike, I thank you so much for replying me, my question this time is what is v_$session, i have seen it on the web several time, but don't know what it is.
And how do I go about using sys.v_$session.machine
Again, thankyou very much
I have a vb front-end access an Oracle database through Oracle ODBC connection, I like to validate user base on the user's IP address, not through their computer terminal name, which accessable through the userenv('TERMINAL') function. I just like to know if there is any Oracle...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.