Re: after servererror trigger to log failed logons

felipe.rivabem_at_gmail.com wrote:
> Iīve psoted sometime ago a question like this but, now itīs more
> specific
>
> I need a fast way to be warned on failed login attempt with some
> importante schemas.
>
> A trigger after servererror, looking for a ora-01017 helps a log, but
> how can I retrieve the user that was used in the attemp?
>
> user or login_user do not work. There must be a way to retrieve this,
> because the audit_session keeps record of it. Is this way public?
>
> thank you
>
> Luiz Felipe Rivabem

I have a demo that does precisely this in Morgan's Library at www.psoug.org.

Scroll down to: SYSTEM TRIGGERS and then on the System Triggers page look for '1017'.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)