Use create login to set the password expiration interval for a new login.
This example creates the new login “joe” with the password “Djdiek3”, and sets the password expiration interval for “joe” to 2 days:
create login joe with password Djdiek3 password expiration 30
The password for “joe” expires after 30 days from the time of day the login account was created, or 30 days from when the password was last changed.
See create login in Reference Manual: Procedures.
