sql - Grant security permissions to a database role -

i'd grant security-level permissions of users of database role. need them able execute alter login, create login, grant, exec sp_addrolemember , etc.

the way i've found far add each user security admin server role following command:

exec sp_addsrvrolemember 'username', 'securityadmin' 

this little cumbersome , i'm not able perform each user. there anyway grant these privileges database role? role, administrator owns db_accessadmin , db_securityadmin schemes, apparently don't help.

not in sql 2008, no. specifically, ability create user-defined server role introduced in sql 2012. , since creating , altering logins server-level permissions, need, well, server-level permission.

but not lost. can you're looking writing stored procedure , using module signing. granted, it's little more cumbersome both , end user, cost may worth benefit.