Re: check expired user accounts

Hi,

You should use an after servererror trigger and trap the error numbers for an expired account or fail logon attempt - from that trigger you can send an alert or email or whatever to correct your encrypted files. The syntax is

create or replace trigger logon_error
after servererror
on database
begin

• do some processing i.e if (is_servererror(-- add errno here --)) then
  • do something end if; end; /

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.