ALTER USER

From InterBase

Go Up to Statement and Function Reference (Language Reference Guide)


Change an existing user. Available in DSQL and isql.

 ALTER USER <name> SET 
 [PASSWORD <password>]
 [[NO] DEFAULT ROLE <name>]
 [[NO] SYSTEM USER NAME <name>]
 [[NO] GROUP NAME <name>]
 [[NO] UID <number>]
 [[NO] GID <number>]
 [[NO] DESCRIPTION <string>]
 [[NO] FIRST NAME <string>]
 [[NO] MIDDLE NAME <string>]
 [[NO] LAST NAME <string>]
 [ACTIVE]
 [INACTIVE];
Argument Description

PASSWORD

Password of user.

[NO] DEFAULT ROLE

Default role.

[NO] SYSTEM USER NAME

System user name for target user.

[NO] GROUP NAME

Group name for target user.

[NO] UID

Target user ID.

[NO] GID

Group ID for target user.

[NO] DESCRIPTION

Description

[NO] FIRST NAME

First name for target user.

[NO] MIDDLE NAME

Middle name for target user.

[NO] LAST NAME

Last name for target user.

ACTIVE

Default. After inactive, reinstates selected user.

INACTIVE

Prevents a user from logging into database.

Description: Alter user changes the definition of an existing user. Only used with database under embedded user authentication.

If you choose to set more than one property value for the user, include a comma between each property-value pair.

Note:
When NO is specified, an argument to the option must not be supplied. No sets the option to a NULL state.

Examples: The following statement modifies the user, JDOE, to be inactive:

ALTER USER JDOE SET INACTIVE;

The next statement modifies the user, JDOE, to be active:

ALTER USER JDOE SET ACTIVE;

See Also

Advance To: