Skip to Main Content

How to get the username in "atfer serverror" trigger ?

MoostiqJan 4 2012 — edited Jan 4 2012
Hi folks;

How to get the name of the user who just miss his connection to the database in a "after serverror" trigger ?
The code of the trigger :
create or replace
TRIGGER TRG_LOGGON_FAILURES 
AFTER SERVERERROR ON DATABASE 
BEGIN
  IF (IS_SERVERERROR(1017)) THEN
  UPDATE utilisateur_ora SET UTO_STA='BLOQUE', UTO_DATE_STATUT=sysdate WHERE UTO_USR_GPL=<var_user>;
  COMMIT;
  END IF;
  
END;
Comments
Post Details
Added on Jan 4 2012
5 comments
48 views