How to trigger which program updated a table ?
From: Maija-Leena <kangasmaki_at_netti.fi.removethis>
Date: Wed, 23 Sep 2009 06:50:07 GMT
Message-ID: <zyjum.15$Lm3.1_at_read4.inet.fi>
Hi,
I need to log some updates and I would like to do it using a trigger which inserts a line to a logtable. I need to know which application (sqlplus, java, toad etc) was used to make the update. I've studied sys_context but didn't find that information. Toad's Session Browser shows programs that are connected to the database, so I think it's possible. Do You know how ?
Date: Wed, 23 Sep 2009 06:50:07 GMT
Message-ID: <zyjum.15$Lm3.1_at_read4.inet.fi>
Hi,
I need to log some updates and I would like to do it using a trigger which inserts a line to a logtable. I need to know which application (sqlplus, java, toad etc) was used to make the update. I've studied sys_context but didn't find that information. Toad's Session Browser shows programs that are connected to the database, so I think it's possible. Do You know how ?
Thanks !
Maija-Leena Received on Wed Sep 23 2009 - 01:50:07 CDT