Re: trigger problem

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 15 Apr 2005 17:07:16 +0200
Message-ID: <425fd87b$0$18321$636a15ce@news.free.fr>

"Noel" <tbal_at_go2.pll-l> a écrit dans le message de news:d3o0ag$gt1$1_at_inews.gazeta.pl...
| Użytkownik Michel Cadot napisał:
|
|
| >
| > This will not work if a user change the name of toad executable
| > to, for instance, gotcha.exe.
|
| Are your sure about it? I did test once upon a time, and renamed
| plus80w.exe to somthing else.
| When i looked into $session it still was plus80w.exe...
|
| On Oracle9i Enterprise Edition Release 9.2.0.3.0 i just did that test,
| renaming plus80w.exe to plus90w.exe.
|
| In v$session there is not program name, but in both cases MODULE is
| SQL*Plus.
|
| --
| Noel

Here a screen copy of an execution on WinNT4 Oracle9.2.0.4:

D:\Oracle\ora920\bin>copy sqlplus.exe foo.exe

        1 fichier(s) copié(s).

D:\Oracle\ora920\bin>foo /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Apr 15 17:00:35 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect test/test_at_mik9
Connected.
SQL> select program from v$session where audsid=userenv('SESSIONID');

PROGRAM

---

foo.exe

SQL> Btw, module is set by SQL*Plus *after* connexion is established and cannot be checked in "after logon" trigger (there module is null).

Regards
Michel Cadot Received on Fri Apr 15 2005 - 10:07:16 CDT