"tty" column in onstat -u

(HP-UX 11i, IDS9.30HC5) Just a comment, really, and wondering if this is the same on other systems? Doing a remote dbaccess query from one box to another, I've found that when I do an 'onstat -u' on the target machine, under the 'tty' column it shows the tty of the session on the machine I issued the query on. This is a potential source of confusion in that it is often the case that someone on the target machine is connected via a terminal session with the same tty id, e.g.: On machine x as user "dba": machine_x:> tty /dev/pts/tk machine_x:> dbaccess sysmaster@machine_ysoc (leave session open) On machine y: machine_y:> onstat -u|grep dba 94000298 Y--P--- 736851 dba tk 94959560 0 1 60 0 machine_y:> onstat -u|grep tk 87d130e4 Y--P--- 726678 nmj tk 978def88 0 1 106 0 94000298 Y--P--- 736851 dba tk 94959560 0 1 60 0 i.e. user 'nmj' on machine y is logged in via terminal tk, which is the same identifier as is used on machine x as user 'dba'. It's no big deal apart from if we wanted to run some kind of auditing on connections.

On 17 Mar, 14:36, i...@perrior.net wrote: > (HP-UX 11i, IDS9.30HC5) > Just a comment, really, and wondering if this is the same on other > systems? > > Doing a remote dbaccess query from one box to another, I've found that > when I do an 'onstat -u' on the target machine, under the 'tty' column > it shows the tty of the session on the machine I issued the query on. > This is a potential source of confusion in that it is often the case > that someone on the target machine is connected via a terminal session > with the same tty id, e.g.: > > On machine x as user "dba": > machine_x:> tty > /dev/pts/tk > > machine_x:> dbaccess sysmaster@machine_ysoc > (leave session open) > > On machine y: > machine_y:> onstat -u|grep dba > 94000298 Y--P--- 736851   dba      tk       94959560 0    1 > 60       0 > > machine_y:> onstat -u|grep tk > 87d130e4 Y--P--- 726678   nmj      tk       978def88 0    1 > 106      0 > 94000298 Y--P--- 736851   dba      tk       94959560 0    1 > 60       0 > > i.e. user 'nmj' on machine y is logged in via terminal tk, which is > the same identifier as is used on machine x as user 'dba'. > > It's no big deal apart from if we wanted to run some kind of auditing > on connections. do onstat -g ses