Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Capture a logon in 7.3.4 ?
As far as I know, V$SESSION is not a table: it is a dynamic view. So you
can't create a trigger on it.
However, the AUD$ IS a table (owned by SYS I think). So the idea of auditing
create session and creating a trigger on this table seems to be a valuable
one.
Michel Gauthier
wozi <wozi_at_dhc.net> wrote in message
news:3FAF3763AD7F8B19.1E143DFFE1669BFC.FE50F7CBFB0E462E_at_library-proxy.airnew
s.net...
> Guy van der Werf wrote in message <374D75C9.28C37296_at_cm-muc.de>...
> >Hello all,
> >This old chestnut must have come up before, but....
> >
> >I need to trigger a stored procedure when a user logs into a 7.3.4 DB.
> >Although possible through application coding (I use Forms, VB and
> >sqlplus), I need something server-side to catch any initial access to
> >the data.
> >
> >I have a theory about an insert trigger on v$session but this sounds a
> >bit flaky (involving v$ tables). If this IS feasible then is a delete
> >trigger on v$session also possible ?
> >
> >All and any thoughs on how to implement a solution is greatly
> >appreciated.
> >
>
> Your theory seem reasonable since triggers cannot fire based on creating
> session with the database. You could also audit CREATE SESSION and create
> trigger on the AUDIT table to check on when the target users log on.
>
> Since triggers fires only for INSERT, DELETE, UPDATE, to trigger a
procedure
> when users connect, the above thoeries might be the only way.
> Then, again, someone else may have other ideas.
>
> Good luck!
>
> just my 2 cents..
> wozi_at_dhc.net
>
>
>
>
Received on Thu May 27 1999 - 15:49:28 CDT