ALTER USER

Alters an existing user.

Syntax

ALTER USER <Name>
PASSWORD <Password>
[DESCRIPTION <Description>]
[ATTRIBUTES <CustomAttributes>]

Usage

Use this statement to alter an existing user.

The password is sent over a network as plain text when this statement is used with a non-encrypted connection to the ElevateDB server.

All clauses after the PASSWORD clause are optional. If they are not specified, then they will not be altered and will stay the same as before the ALTER USER statement was executed.

Examples

-- The following statement changes the password of
-- the "Joe Smith" user.

ALTER USER "Joe Smith"
PASSWORD 'New1030'

Required Privileges

The current user must be granted the system-defined Administrators role or be logged in as the same user that is being altered in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations

This statement deviates from the SQL 2003 standard in the following ways:

Deviation

Details

Extension

This SQL statement is an ElevateDB extension

More Support Options

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Incident Reports

Roadmap