Is it possible to set a future expiration date on a user account in Oracle? Or to set a account status to
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.