ALTER CREDENTIAL

Change properties of a credential.

Syntax
      ALTER CREDENTIAL credential WITH IDENTITY = 'identity'
	      [, SECRET = 'secret']

A credential is a record of the authentication information required to connect to a resource outside SQL Server. Most credentials are a Windows username/password.

When IDENTITY is a Windows username, the SECRET can be the password. Secret is encrypted using the service master key.

Example

ALTER CREDENTIAL MyCredential WITH IDENTITY = 'JDoe';
GO

The above will set the secret (password) for MyCredential to NULL

"In my end is my beginning" ~ Mary Stuart, Queen of Scots

Related commands:

CREATE CREDENTIAL
DROP CREDENTIAL
sys.credentials


© Copyright SS64.com 1999-2014
Some rights reserved