ALTER USER

The ALTER USER statement allows a user to change the user's own password. A user with the ADMIN privilege can change another user's password.

This statement also allows a user to change another user from internal to external or from external to internal.

Required privilege

No privilege is required to change the user's own password.

ADMIN privilege is required to change another user's password.

ADMIN privilege is required to change users from internal to external and from external to internal.

SQL syntax

ALTER USER user IDENTIFIED BY {password | "password"}
ALTER USER user IDENTIFIED EXTERNALLY

Parameters

The ALTER USER statement has the parameters:

Parameter	Description
`user`	Name of the user whose password is being changed.
`IDENTIFIED` `BY`	Identification clause.
`password` `\|"password"`	Specifies the password that identifies the internal user to the TimesTen database.
`EXTERNALLY`	Identifies the operating system `user` to the TimesTen database. To perform database operations as an external user, the process needs a TimesTen external user name that matches the user name authenticated by the operating system or network. A password is not required by TimesTen because the user has been authenticated by the operating system at login time.

Description

Database users can be internal or external.
- Internal users are defined for a TimesTen database.
- External users are defined by an external authority, such as the operating system. External users cannot be assigned a TimesTen password.
If you are an internal user connected as user, execute this statement to change your TimesTen password.
Passwords are case-sensitive.
You cannot alter a user across a client/server connection. You must use a direct connection when altering a user.

Examples

To change the password for internal user terry to "12345" from its current setting, use:

ALTER USER terry IDENTIFIED BY "12345";
User altered.

To change user terry to an external user:

ALTER USER terry IDENTIFIED EXTERNALLY;
User altered.

To change user terry back to an internal user, provide a password:

ALTER USER terry IDENTIFIED BY "secret";
User altered.