ALTER LOGIN |
Modifie la connexion |
---|---|
Microsoft SQL Server |
Syntaxe
ALTER LOGIN login_name { status_option | WITH set_option [ ,... ] | cryptographic_credential_option } [;] status_option ::= ENABLE | DISABLE set_option ::= PASSWORD = 'password' | hashed_password HASHED [ OLD_PASSWORD = 'oldpassword' | password_option [password_option ] ] | DEFAULT_DATABASE = database | DEFAULT_LANGUAGE = language | NAME = login_name | CHECK_POLICY = { ON | OFF } | CHECK_EXPIRATION = { ON | OFF } | CREDENTIAL = credential_name | NO CREDENTIAL password_option ::= MUST_CHANGE | UNLOCK cryptographic_credentials_option ::= ADD CREDENTIAL credential_name | DROP CREDENTIAL credential_name |
Description
Cette instruction permet de changer les propriétés d'un compte de connexion SQL Server.
Dernière mise à jour : Vendredi, le 19 Juin 2020