Grant User Logins w/ nothing else

• Chad Poulson

  SSC Enthusiast

  Points: 142

  More actions

  August 9, 2005 at 12:10 pm

  #165573

  We need to be able to allow certain users to create database logins without giving them administrator rights. Is this even possible?

   

  Thanks

• gbn

  SSCertifiable

  Points: 6429

  More actions

  August 10, 2005 at 2:22 am

  #580933

  Look at sp_addsrvrolemember in BOL.

  "securityadmin" is what you're after.

  Cheers