Alter logins rights to user/Login

• anoop.mig29

  SSCrazy

  Points: 2224

  More actions

  May 2, 2014 at 11:24 am

  #286455

  Hi i want to provide create and alter login rights to user where he can change password of logins.Apart of securityadmin rights what can be done.

  I mean user with securityadmin rights cannot create/alter password of logins with sysadmin rights

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  May 5, 2014 at 1:31 am

  #1710643

  You need to grant ALTER ANY LOGIN to do that, which is the axact same permission granted to securityadmin.

  In other words, you can't do that directly.

  You should grant ALTER LOGIN permissions on the individual logins instead.

  -- Gianluca Sartori