alter role

Description     

                       Defines mutually exclusive relationships between roles; adds, drops, and
                       changes passwords for roles; specifies the password expiration interval, the
                       minimum password length, and the maximum number of failed logins allowed
                       for a specified role. alter role is also used to lock and unlock roles.

Syntax                 alter role role1 { add | drop } exclusive
                                 { membership | activation } role2
                       alter role role_name [add passwd "password" |
                                 drop passwd] [lock | unlock]
                       alter role { role_name | "all overrides" }
                                 set { passwd expiration | min passwd length |
                                 max failed_logins } option_value

Parameters

                       role1
                          is one role in a mutually exclusive relationship.
                       add
                          adds a role in a mutually exclusive relationship; adds a password to a role.
                       drop
                          drops a role in a mutually exclusive relationship; drops a password from a
                          role.
                       exclusive
                          makes both named roles mutually exclusive.
                       membership
                          does not allow you to grant users both roles at the same time.
                       activation
                          allows you to grant a user both roles at the same time, but does not allow the
                          user to activate both roles at the same time.
                       role2
                          is the other role in a mutually exclusive relationship.
                       role_name
                          is the name of the role for which you want to add, drop, or change a
                          password. Use role_name to specify the password expiration interval, the
                          minimum password length, and the maximum number of failed logins.
                       passwd
                          adds or drops a password to a role.
                                                                                                      11
Reference Manual: Commands
alter role
           password
               is the password to add to a role. Passwords must be at least 6 characters in
               length and must conform to the rules for identifiers. You cannot use
               variables for passwords.
           lock
               locks the specified role.
           unlock
               unlocks the specified role.
           all overrides
               applies the setting that follows to the entire server rather than to a specific
               role.
           set
               activates the option that follows it.
           passwd expiration
               specifies the password expiration interval in days. It can be any value
               between 0 and 32767, inclusive.
           min passwd length
               specifies the minimum length allowed for the specified password.
           max failed_logins
               specifies the maximum number of failed login attempts allowed for the
               specified password.
           option_value
               specifies the value for passwd expiration, min passwd length, or max
               failed_logins. To set all overrides, set the value of option_value to -1.