after servererror trigger to log failed logons

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 Received on Thu Mar 16 2006 - 11:30:05 CST