Alters the password for an existing user,
The password of the ident given by
ident-nameis changed to the string given in
GROUPidents do not have passwords, therefore the
ALTER IDENTstatement cannot be used on a
The password can only be changed by the ident or by the creator of the ident.
The password must be at least 1 and at most 18 characters long and may contain any characters except the space character. The case of alphabetical characters is significant.
The password string must be enclosed in string delimiters, which are not included as part of the password.
Change the user SAMMY's password to
SaXm2Jo.ALTER IDENT SAMMY USING 'SaXm2Jo';
For more information, see the Mimer SQL User's Manual, Altering Databanks, Tables and Idents.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40