MicroStrategy ONE

Alter User statement

Modifies the properties of a user.

If you are modifying the NTLINK parameter, you must execute this statement in a Windows environment. The NTLINK parameter does not function in a UNIX or Linux environment.

Copy 
ALTER USER "login_name" [NAME "new_login_name"] [(NTLINK "new_nt_user_id" | NTSID "new_user_ntsid")] [PASSWORD "new_user_password"] [FULLNAME "new_user_full_name" [DESCRIPTION "new_user_description"] [LONGDESCRIPTION "new_long_description"] [LDAPLINK "new_LDAP_user_name"] [TRUSTEDLOGIN "new_trusted_authenticated_id"] [WHLINK "new_warehouse_login"] [WHPASSWORD "new_warehouse_password"] [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)] [IN GROUP "new_user_group_name"];

where:

  • USER "login_name" is the login name of the user to be altered, of type string.

  • NAME "new_login_name" is the new login name of the user, of type string.

  • NTLINK "new_nt_user_id" is the new Windows user name ID to be linked to the user, of type string, with format \DOMAIN\username.

  • NTSID "new_user_ntsid" is the new NTSID to be linked to the user, of type string.

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

  • FULLNAME "new_user_full_name" is the new full name for the user, of type string.

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

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

  • LDAPLINK "new_LDAP_user_name" is the new LDAP user to be linked to the user, of type string.

  • TRUSTEDLOGIN "new_trusted_authenticated_id" is the new trusted authentication login to be linked to the new user, of type string.

  • WHLINK "new_warehouse_login" is the new warehouse login to be linked to the user, of type string.

  • WHPASSWORD "new_warehouse_password" is the new warehouse password (WH passthrough) to be used for the warehouse login, of type string.

  • ALLOWCHANGEPWD indicates whether the user is allowed to change her password.

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

  • CHANGEPWD indicates whether the user must change her password the next time she logs on.

  • PASSWORDEXP indicates how often the user's password expires:

    • NEVER indicates that the password does not expire.

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

    • new_expiration_date is the date on which the new user's password expires, in the mm/dd/yyyy format.

  • PASSWORDEXPFREQ number_of_days DAYS is the number of days that pass every cycle before the new user's password expires, of type integer.

  • ENABLED | DISABLED indicate whether the user is enabled or disabled in the MicroStrategy system.

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

Example

Copy 
ALTER USER "palcazar" DESCRIPTION "User 
 created for testing purposes" GROUP "Public" PASSWORDEXP 
 IN 5 DAYS;