开发者

Expanded securityadmin

开发者 https://www.devze.com 2022-12-28 10:55 出处:网络
I\'m aware that s开发者_Python百科ysadmin is documented as the server role necessary for creating logins (SQL/Windows-integrated); nevertheless, I\'m tasked to find out if there\'s any other server ro

I'm aware that s开发者_Python百科ysadmin is documented as the server role necessary for creating logins (SQL/Windows-integrated); nevertheless, I'm tasked to find out if there's any other server role (built-in or otherwise) that can be used.

To be specific, I'm looking to setup one or two logins with access to create logins, create [database] users, assign users to [database] roles. Potentially reset passwords, but most of the logins are Windows-integrated and it's not necessary. Cannot have access to data at all, nor can these logins have rights to update tables nor create/update roles.

Seems my only options so far are to set these 2 logins with securityadmin server role and for the specific databases, configure with db_securityadmin and db_accessadmin... but this configuration doesn't allow for creating logins.

0

精彩评论

暂无评论...
验证码 换一张
取 消