Re: How to trigger which program updated a table ?

From: joel garry <>
Date: Wed, 23 Sep 2009 09:01:53 -0700 (PDT)
Message-ID: <>

On Sep 22, 11:50 pm, "Maija-Leena" <> 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?


-- is bogus.
Checkers speech day.
Received on Wed Sep 23 2009 - 11:01:53 CDT

Original text of this message