Is it possible to set a future expiration date on a user account in Oracle? Or to set a account status to EXPIRE(GRACE)
We want to implement a more strict password policy, and I've created the new Profile, but would like to use Oracle's password grace period function to warn users (instead of just running a script to immediately expire the user accounts).
(In short, yes I can and will send out an email telling everyone their password will expire in 10 days, but I'd rather have Oracle tell them when they log in so they can't deny seeing the warning)
I don't see an option for ALTER USER...
for expiration dates.
Also when I added some users to the new profile (which has a 90 day Password Life Time
and a 30 day Password Grace Time
for some reason it automatically set their expiration date to 51 days and 6 hours from now, which I thought was rather odd.