Alter Users In Group statement

Modifies one or more properties of all users in a user group.

ALTER USERS IN USER GROUP "user_group_name" [PASSWORD "new_user_password"] [DESCRIPTION "new_user_description"] [LONGDESCRIPTION "new_long_description"] [ALLOWCHANGEPWD (TRUE | FALSE)] [ALLOWSTDAUTH (TRUE | FALSE)] [CHANGEPWD (TRUE | FALSE)] [PASSWORDEXP (NEVER | (IN new_number_of_days DAYS | ON new_expiration_date))] [PASSWORDEXPFREQ number_of_days DAYS] [(ENABLED | DISABLED)] [GROUP "new_user_group_name"];

where:

• USER GROUP "user_group_name" is the name of the user group that contains the users to be altered, of type string.

• PASSWORD "new_user_password" is the new password for the users, of type string.

• DESCRIPTION "new_user_description" is the new description of the users, of type string.

• LONGDESCRIPTION "new_long_description" is the new long description of the users, of type string.

• ALLOWCHANGEPWD indicates whether the users are allowed to change their password.

• ALLOWSTDAUTH indicates whether to allow standard MicroStrategy authentication for the users.

• CHANGEPWD indicates whether the users must change their password the next time she logs on.

• PASSWORDEXP indicates how often the users' passwords expire:

  • NEVER indicates that the passwords do not expire.

  • new_number_of_days DAYS is the number of days that should pass before the new user's passwords expire, of type integer.

  • new_expiration_date is the date on which the new users' passwords expire, in the mm/dd/yyyy format.

• PASSWORDEXPFREQ number_of_days DAYS is the number of days that pass every cycle before the new users' passwords expire, of type integer.

• GROUP "new_user_group_name" is the name of a user group to which the users are to be added (be made member of), of type string.

Example

ALTER USERS IN USER GROUP "Managers" PASSWORD 
 "test" CHANGEPWD TRUE;