Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


ALTER IDENT


Alters the password for an existing user, OS_USER or PROGRAM ident.

Usage

Embedded/Interactive/ODBC/JDBC.

Description

The password of the ident given by ident-name is changed to the string given in password-string.

Restrictions

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

The password can only be changed by the ident or by the creator of the ident.

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.

Example

Change the user SAMMY's password to SamJo.

 ALTER IDENT SAMMY
 USING 'SamJo';
 

For more information, see the Mimer SQL User's Manual, chapter 9, Altering Databanks, Tables and Idents.

Standard Compliance

Standard
Compliance
Comments
X/Open-95
SQL-92
MIMER EXTENSION
The ALTER IDENT statement is a Mimer SQL extension.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX