Skip to main content

ALTER LOGIN (bSQL) | Blockpoint Docs

Changes the password for the specified login.

bSQL Syntax Conventions

Syntax

ALTER LOGIN login_name PASSWORD="new_password"

Arguments

login_name
Specifies the login to change.

new_password
A case-sensitive password.

Permissions

To run this command you need one or more of these permissions:

MANAGEMENT permissions required on the master database.

MANAGEMENT permissions default to members of the admin fixed database role. Members of the admin fixed database role can transfer permissions to logins and users.

Remarks

Changing a password will not have any effect on current connections and will only take effect on the next login.

Examples

Change a password.

The following example changes the system password to orangeKitten.

ALTER LOGIN system PASSWORD = "orangeKitten";

See Also