Prevent User from Changing Login Password

• babul_miah

  Grasshopper

  Points: 13

  More actions

  April 17, 2011 at 3:19 pm

  #249059

  Hi,

  Is there a way to prevent a certain user who has SQL Server login from changing thier password?

  Thanks

• K. Brian Kelley

  SSC Guru

  Points: 114704

  More actions

  April 20, 2011 at 3:19 am

  #1313801

  Short of using something like a server-level DDL trigger, no.

  K. Brian Kelley
  @kbriankelley