Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search

Syntax [Table of Contents] Examples

Reference Manual: Commands

[-] Chapter 1 Commands
[-] alter role
[-] Parameters

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.

passwd

adds a password to a 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.


Syntax [Table of Contents] Examples