Set, alter or drop the password for an existing ident, or add or drop
ALTER IDENTstatement is used for either adding and dropping
OS_USERlogins for a
USERident, or for setting and dropping the password for an ident. Adding an
OS_USERlogin for an ident makes it possible to connect to Mimer SQL without giving a password. See USER Identsfor more details.
GROUPidents do not have passwords, therefore the
ALTER IDENTstatement cannot be used on a
OS_USERlogins can only be added or dropped for
USERidents. It is only the creator of the ident that may add or drop
Dropping a password is only allowed for
USERidents. It is only the creator of the ident that may drop the password.
The password can only be changed by the ident or by the creator of the ident. An ident may only change the password if the password already has been set.
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.
All letters in
OS_USERlogin names are treated as uppercase in Mimer SQL, regardless of operating system conventions. See SQL Identifiers for more information on naming objects.
Change the user SAMMY's password to
SaXm2Jo:ALTER IDENT SAMMY SET PASSWORD 'SaXm2Jo';
OS_USERlogin Kessler to the ident Kramer:ALTER IDENT KRAMER ADD OS_USER 'KESSLER';
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