Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Credentials Expand / Collapse
Posted Tuesday, April 29, 2014 7:44 AM

SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 14, 2014 12:15 PM
Points: 245, Visits: 348
Is there a way to give a user rights to change the password on a credential without giving the Alter Any Credential permission?
Post #1565928
Posted Wednesday, April 30, 2014 7:40 AM



Group: General Forum Members
Last Login: 2 days ago @ 8:46 AM
Points: 5,276, Visits: 12,468
From BOL:


Requires ALTER ANY CREDENTIAL permission. If the credential is a system credential, requires CONTROL SERVER permission.

In other words, no. Not directly at least.
You can always wrap that functionality in a stored procedure with EXECUTE AS or let the user impersonate in some other way.

Gianluca Sartori

How to post T-SQL questions
Post #1566397
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse