how can I find out what is the OS that a user is logged into. I tried the v$session and SYS_CONTEXT function but could not find the info that I am looking for. for example a user is on windows 10 and runs some SQL on SQL*Developer or login to the unix and runs some script in there thru SQLplus. i need to be able to see if the user is in the Windows 10 or unix or any OS.

thanks,
warren

how can I find out what is the OS that a user is logged into. I tried the v$session and SYS_CONTEXT function but could not find the info that I am looking for. for example a user is on windows 10 and runs some SQL on SQL*Developer or login to the unix and runs some script in there thru SQLplus. i need to be able to see if the user is in the Windows 10 or unix or any OS.

thanks,
warren

What about a 3-tier application like below? What OS should be reported when access is via smart phone?


In a 3-tier application, the database server is far removed from the end user clicking the button.

EndUser<=>browser<=>webserver<=>ApplicationServer<=>DatabaseServer

It's still not clear exactly what you are looking for (or why). Suppose I'm on my windows workstation and ssh to a linux db server. From that ssh session, I start sqlplus and issue queries to the database. Which OS do you consider the client to be on, which OS do you want to report. And what process, where, wants to interrogate and get this information?

Have a look at V$SESSION_CONNECT_INFO.NETWORK_SERVICE_BANNER.

EdStevens wrote on Thu, 01 November 2018 07:37

It's still not clear exactly what you are looking for (or why). Suppose I'm on my windows workstation and ssh to a linux db server. From that ssh session, I start sqlplus and issue queries to the database. Which OS do you consider the client to be on, which OS do you want to report. And what process, where, wants to interrogate and get this information?

good point and we also thought about that. as long as we can get the OS it will be a big help for us to trace back where the user logs into, one step at a time.

Yeah, so WHICH OS? THat's what I tried to ask before but your answer is not as explicit as my question and ignored part of my questions.. like what process do you envision collecting this information and how do you envision it being reported? Perhaps you should step back and tell us what you are really trying to get and quite worrying (for now) about the technique. Suppose that, somehow, you come up with 'connection x is from a client on Windows 7'. Now what do you do with that? Answering these types of question may very well reveal that you are trying to solve the wrong problem.