Post reply

SQL Credentials

  • April 29, 2014 at 7:44 am

    #307092

    Is there a way to give a user rights to change the password on a credential without giving the Alter Any Credential permission?

  • April 30, 2014 at 7:40 am

    #1709835

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply