ALTER USER username IDENTIFIED {BY new_password | EXTERNALLY} [CONNECTIONS integer]
Usage
The ALTER USER statement modifies the password of a user or changes the authentication type of a user.
BY new_password
The ALTER USER username IDENTIFIED BY new_password statement modifies the password of a specified user.
IDENTIFIED EXTERNALLY
The ALTER USER username IDENTIFIED EXTERNALLY changes the authentication of the user to use external authentication. When using external authentication, the username must match the user name of an operating system user account.
Additionally, to use external authentication, you must enable the use of solidDB® Global Security Kit (GSKit). For more details, see Enabling encryption with solidDB® Global Security Kit (GSKit).
Note When using external authentication on Windows systems, your environment might require you to provide the user name in the two-part format of domain_name\username or username@domain_name. You can specify the domain_name 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 integer
The CONNECTIONS keyword defines the maximum number of connections for a user.
integer is a positive integer that defines the number of connections allowedfor the specified user. The default value is 0, which means that there is nolimit on concurrent connections for the specified user.
Once the maximum number of connections have been made, newconnections 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.
Only users with administrator rights can change the password or authentication type of other users.
Examples
ALTER USER MANAGER IDENTIFIED BY O2CPTG;
ALTER USER solid1 IDENTIFIED EXTERNALLY;
ALTER USER solid1 IDENTIFIED EXTERNALLY CONNECTIONS 7;