Re: How to trigger which program updated a table ?
From: joel garry <joel-garry_at_home.com>
Date: Wed, 23 Sep 2009 09:01:53 -0700 (PDT)
Message-ID: <9cd8dfa0-1b6b-4a83-8707-db0e3846b1a6_at_y28g2000prd.googlegroups.com>
On Sep 22, 11:50 pm, "Maija-Leena" <kangasm..._at_netti.fi.removethis> wrote:
> 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
Date: Wed, 23 Sep 2009 09:01:53 -0700 (PDT)
Message-ID: <9cd8dfa0-1b6b-4a83-8707-db0e3846b1a6_at_y28g2000prd.googlegroups.com>
On Sep 22, 11:50 pm, "Maija-Leena" <kangasm..._at_netti.fi.removethis> wrote:
> 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
Note that all that information is easily spoofable, so I echo Palooka and Mladen: Why?
jg
-- _at_home.com is bogus. Checkers speech day.Received on Wed Sep 23 2009 - 11:01:53 CDT