On 8/15/05, Mike Schmitt <mschmitt@(protected)> wrote: > > Hi All, > > I am trying to catch failed login attempts by using an after servererror > database trigger. We would like to be able to catch the username that is > being provided with these attempts, but so far I haven't had any luck. > > Is is possible to capture the name that was provided as part of the logon > attempt and record that information, or do we have to use a different > method? > > The edited trigger/proc we are using look like the following (We are using > 9.2.0.4): > >
Mike,
Instead of coding this by hand, why not just leverage the provided functionality?
SQL> show parameter audit_trail
NAME TYPE VALUE -- ---- ---- ---- ---- ---- ---- --- -- ---- --- -- ---- ---- ---- ---- ---- -- audit_trail string TRUE
