Moving/Copying Security Groups

• Jinx-640161

  Ten Centuries

  Points: 1218

  More actions

  May 15, 2008 at 1:47 am

  #96300

  Hi,

  Is there a way to move/copy a Users group (under a specific database) to the main Security, logins groups for a sql server, without having to recreate the whole group 'manually'?

  Thanks!

  Jinx.

• sharon-644450

  Default port

  Points: 1442

  More actions

  May 18, 2008 at 1:30 am

  #816928

  i guess you are talking about orphaned logins.

  you can chek it using

  sp_change_users_login 'report'

  sp_change_users_login 'update_one', [ , [ @UserNamePattern ] 'user' ] [ , [ @LoginName = ] 'login' ]