![]() | ![]() |
Home |
|
|
Reference Manual: Commands |
|
| Chapter 1 Commands |
|
| alter role |
|
| Parameters |
is one role in a mutually exclusive relationship.
addadds a role in a mutually exclusive relationship; adds a password to a role.
dropdrops a role in a mutually exclusive relationship; drops a password from a role.
exclusivemakes both named roles mutually exclusive.
membershipdoes not allow you to grant users both roles at the same time.
activationallows 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.
role2is the other role in a mutually exclusive relationship.
role_nameis the name of the role for which you want to add, drop, or change a password.
passwdadds a password to a role.
passwordis 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.
locklocks the specified role.
unlockunlocks the specified role.
all overridesapplies the setting that follows to the entire server rather than to a specific role.
setactivates the option that follows it.
passwd expirationspecifies the password expiration interval in days. It can be any value between 0 and 32767, inclusive.
min passwd lengthspecifies the minimum length allowed for the specified password.
max failed_loginsspecifies the maximum number of failed login attempts allowed for the specified password.
option_valuespecifies the value for passwd expiration, min passwd length, or max failed_logins. To set all overrides, set the value of option_value to -1.
|
|