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
Author
Message
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 4:52 AM
Points: 4,378, Visits: 10,663
From BOL:

ALTER CREDENTIAL (Transact-SQL)

Permissions
--------------------------------------------------------------------------------
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

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1566397
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse