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;