Sql secruity related question

• vsamantha35

  SSChampion

  Points: 11551

  More actions

  October 15, 2019 at 6:37 am

  Go to Answer

  #3688789

  Hi All,

  This is Security related question. Please help.

  Is the below command equivalent to EXEC sp_change_users_login 'Update_One', 'dbuser', 'login'; ?

  USE [DatabaseName]

  ALTER USER [DbUserName]

  WITH LOGIN = [LoginName]

  if so, from which version MICROSOFT has changed this ? does both commands use to fix a orphan user?

  Thanks,

  Sam

• ratbak

  Ten Centuries

  Points: 1379

  More actions

  October 15, 2019 at 1:24 pm

  Answer

  #3688858

  2005.

  Both work, but sp_change_users_login "is in maintenance mode and may be removed in a future version of Microsoft SQL Server."

• vsamantha35

  SSChampion

  Points: 11551

  More actions

  October 15, 2019 at 2:43 pm

  #3688909

  Thank you Rick.