Might be valuable, but it's completely unsupported. Triggers on SYS objects are
> 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
> Michel Gauthier
> > >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
> > 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..
Project Manager Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education (650)607 0109 (local)
SQL> select standard_disclaimer, witty_remark
2 from company_requirements;
Opinions are mine and do not necessarily reflect those of Oracle
"Controlling application developers is like herding cats."
Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!"
Bruce Pihlamae, long term ORACLE DBA