alter login

• TRACEY-320982

  SSChampion

  Points: 13653

  More actions

  August 30, 2008 at 2:24 pm

  #192123

  created procedure so that a web page can run command to alter the users passwords

  Procedure is

  create procedure usp_alter_login

  as

  Alter Login...etc.

  What would be the rights for the weblogin that i would need to grant.

  I gave securityadmin but i was wondering if there anything else i could do then give this right to the user.

  Cheers

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  September 3, 2008 at 11:24 am

  #866671

  If I am not mistaken, you just need to give execute permission for the stored proc. I dont think you need to give Sys previleges.

  -Roy