July 23, 2014 at 6:13 am
What is the needed permission to create credential except for sysadmin?
Already granted securityadmin but still user does not have permission to perform this action.
Please help. Thanks!
July 23, 2014 at 10:42 am
From BOL:
Permissions
Requires ALTER ANY CREDENTIAL permission to create or modify a credential and ALTER ANY LOGIN permission to map a login to a credential.
Also from BOL:
Members of the securityadmin fixed server role manage logins and their properties. They can GRANT, DENY, and REVOKE server-level permissions. They can also GRANT, DENY, and REVOKE database-level permissions if they have access to a database. Additionally, they can reset passwords for SQL Server logins.
And this from 2008 R2 BOL (they don't have an updated version of this article):
securityadmin - ALTER ANY LOGIN
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply