question

saurabhsrivastava avatar image
saurabhsrivastava asked

Permissions required on sql server

We want to take a group out of sysadmin but grant them a role so they can do following 1. add, change, remove database access on prod servers for users, groups and service accounts. 2. create and delete roles and grant access to the roles. Which permissions or role would be suited for these operations as securityadmin and db_securityadmin does not cover all the aspects
securityrolessqlserver 2008r2serverroles
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.