ALTER USERusernameIDENTIFIED {BYnew‑password | EXTERNALLY} [CONNECTIONSinteger]
Access requirements
SYS_ADMIN_ROLE role
Usage
Use the ALTER USER statement to modify the password of a user or change the authentication type of a user.
Parameters, clauses, keywords, and variables
▪ IDENTIFIED BY: Defines a new password for the specified user.
▪ IDENTIFIED EXTERNALLY: Changes the authentication of the specified user to use external authentication. When using external authentication, username must match the user name of an operating system user account.
Note If you use external authentication on Windows systems, your environment might require you to provide the user name in the two-part format of domain‑name\usernameor username@domain‑name. You can specify the domain‑name by using the General.DefaultDomainName parameter. The solidDB server uses the value of the General.DefaultDomainName parameter to resolve the two-part user ID as expected by the Windows operating system.
▪ CONNECTIONS: Defines the maximum number of connections that the specified user can have.
The default value is 0, which means that there is no limit on concurrent connections for the specified user.
After the maximum number of connections is reached, new connections fail with the following error message:
Server Error 14559: Exceeded maximum number of allowed connections for user. Close existing connections or contact administrator to increase the limit.
Examples
ALTER USER MANAGER IDENTIFIED BY O2CPTG;
ALTER USER solid1 IDENTIFIED EXTERNALLY;
ALTER USER solid1 IDENTIFIED EXTERNALLY CONNECTIONS 7;