Re: How to trigger which program updated a table ?
From: gazzag <gareth_at_jamms.org>
Date: Wed, 23 Sep 2009 06:02:13 -0700 (PDT)
Message-ID: <421f16bb-5d40-4afc-892b-34fb8c65d2cf_at_r36g2000vbn.googlegroups.com>
On 23 Sep, 07:50, "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 06:02:13 -0700 (PDT)
Message-ID: <421f16bb-5d40-4afc-892b-34fb8c65d2cf_at_r36g2000vbn.googlegroups.com>
On 23 Sep, 07:50, "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
Oacle version?
Some ideas:
- AFTER LOGON ON DATABASE trigger and V$SESSION view.
- Oracle Fine Grain Auditing (may be overkill depending on your requirement)
HTH -g Received on Wed Sep 23 2009 - 08:02:13 CDT