ALTER CREDENTIAL SYNTAX – SQL SERVER
Posted on : 05-07-2011 | By : Devi Prasad | In : Credentials
0
ALTER CREDENTIAL SYNTAX
SYNTAX:
ALTER CREDENTIAL credentialname WITH IDENTITY = 'identityname'
, SECRET = 'secret'
The IDENTITY and SECRET for a credential can be changed using ALTER CREDENTIAL.
Example of Alter Credential:
USE [master] GO ALTER CREDENTIAL [credential1] WITH IDENTITY = N'username1', SECRET = N'password1' GO
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
Double Click on the credential name
- DoubleClick on the Credential name
- Credential properties dailog will pop up
Credential Properties
- Now change the credential properties such as IDENTITY, Password and click on Ok
Reference : Devi Prasad (sqlserverlearner.com)
Do you like my blog?
If you liked reading this blog, please help spread the word by sharing this blog with your friends.
Need Help On SQL Server?
Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.
Tags: alter credential explained in detail, example of alter credential, how to alter credential, how to alter credential using ssms
