how to find external users

calyan · #1 (**permalink**) 09-20-06, 05:30

there are some external apps accessing my db. ok

i am able to see the audit activities for the users who are
internally using the db, that is using dbaccess.

but some VB apps, even nobody knows who are using it.accessing
this db.

how to find those users?

Tyveleyn · #2 (**permalink**) 09-20-06, 09:53

Hi,

In a UNIX system 'onstat -u' produces:

Code:

Userthreads                                                                     
address  flags   sessid   user     tty      wait     tout locks nreads   nwrites
                                                                                
2a48ad48 Y--P--- 7808     user1    PC16     2be73a50 0    1     234      86     
2a48b338 Y--P--- 7839     user1    1        2bf42b88 0    1     0        0      
2a48d6d8 Y--P--- 7801     user2    PC24     2ba3c698 0    1     2        74

where under tty either the to the loginsession assigned terminal id (in this case '1' for user1) or the hostname ('PC16' and 'PC24' for user1 and user2) are shown. Since VB is typically a client application I guess through this these sessions are distinguishable from (local) dbaccess sessions. Don't know right now what it looks like in Windows...

Regards

calyan · #3 (**permalink**) 09-21-06, 05:42

thanks for info

Internet Services

Web Development

Digital Marketing

Consumer Tech