Use create role to set the password expiration interval for a new role.
This example creates the new role intern_role with the password “temp244”, and sets the password expiration interval for intern_role to 7 days:
create role intern_role with passwd "temp244", passwd expiration 7
The password for intern_role expires after 7 days from the time of day you created the role, or 2 days from when the password was last changed.
password expiration interval specifies the password expiration interval in days. It can be any value between 0 and 32767, inclusive. For example, if you create a new login on August 1, 2007 at 10:30 AM, with a password expiration interval of 30 days, the password expires on August 31, 2007 at 10:30 AM
For details on the syntax and rules for using passwd expiration, see create role in the Reference Manual: Commands.
