Problem with logon trigger

Hello,

we are using Oracle 8.1.7 on a W2K server.

I have a problem with a logon trigger.
The idea is to store the OS-Username in a separate table when a user logs on:

CREATE OR REPLACE TRIGGER DB_LOGON
after logon on database
begin
 INSERT INTO T_SESSIONS (SESSIONID, TERMINAL, OSUSER, LOGONTIME, LASTALIVE)
 SELECT userenv('sessionid'), TERMINAL, OSUSER, sysdate as s1, sysdate as s2
 FROM SYS.V_$SESSION WHERE AUDSID = userenv('sessionid'); end;

Problem: when creating this trigger, I get: "SYS.V_$SESSION must be declared".

However, in a normal SQL PLUS Window, the SQL-statement contained in the trigger works fully OK!! I tried to create a synonym to SYS.V_$SESSION, but I get the same error.

Do you have any hints??

Thanks in advance
Georg Scholz Received on Mon Jan 14 2002 - 03:22:56 CST