In our prod db we have application users, they have a profile other than default so there are checks on their passwords expire, etc. We now need to give them a certain date so that the users will be expired at that date e.g. on 01.01.2010 we want the application users expire regardless of the profile rules.

Do you know how can this be done? I would scheduel a job checking the date and expiring the users but I would rather do it in a more elegant way if possible.

DB is 10gR2

thanks in advance,