Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


ALTER IDENT


Set, alter or drop the password for an existing ident, or add or drop OS_USER for a USER ident.



Usage

Embedded/Interactive/ODBC/JDBC.

Description

The ALTER IDENT statement is used for either adding and dropping OS_USER logins for a USER ident, or for setting and dropping the password for an ident. Adding an OS_USER login for an ident makes it possible to connect to Mimer SQL without giving a password. See USER Identsfor more details.

Restrictions

GROUP idents do not have passwords, therefore the ALTER IDENT statement cannot be used on a GROUP ident.

OS_USER logins can only be added or dropped for USER idents. It is only the creator of the ident that may add or drop OS_USER logins.

Dropping a password is only allowed for USER idents. 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.

Notes

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_USER login names are treated as uppercase in Mimer SQL, regardless of operating system conventions. See SQL Identifiers for more information on naming objects.

Example

Change the user SAMMY's password to SaXm2Jo:

 ALTER IDENT SAMMY SET PASSWORD 'SaXm2Jo';
 

Add the OS_USER login 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.

Standard Compliance

Standard
Compliance
Comments

Mimer SQL extension
The ALTER IDENT statement is a Mimer SQL extension.


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX