ALTER CREDENTIAL SYNTAX
SYNTAX:
[sql]
ALTER CREDENTIAL credentialname WITH IDENTITY = ‘identityname’
, SECRET = ‘secret’
[/sql]
The IDENTITY and SECRET for a credential can be changed using ALTER CREDENTIAL.
Example of Alter Credential:
[sql]
USE [master]
GO
ALTER CREDENTIAL [credential1] WITH IDENTITY = N’username1′, SECRET = N’password1′
GO
[/sql]
USING SQL SERVER MANAGEMENT STUDIO (SSMS) TO ALTER CREDENTIAL:
- Open SSMS and connect to the server in object explorer.
- Expand server and Security
- In Security Expand
- DoubleClick on the Credential name
- Credential properties dailog will pop up
- Now change the credential properties such as IDENTITY, Password and click on Ok