Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with logon trigger
You'll logon as SYS and you must create PUBLIC SYNONYM.
Sergey M.
"Georg Scholz" <georg.scholz_at_ubisol.at> wrote in message
news:3e738c1a.0201140122.33818d4b_at_posting.google.com...
> 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 - 16:05:13 CST