Use alter login to change the password expiration interval for an existing login, add a password expiration interval to a login that did not have one, or remove a password expiration interval. alter login only effects login passwords, not role passwords.
This example changes the password expiration interval for the login “joe” to 5 days:
alter login joe modify password expiration 30
The password expires 30 days from the time of day you ran password expiration.
See alter login in Reference Manual: Commands.
