Script out Database users with roles/permissions

• balasach82

  SSCrazy Eights

  Points: 9653

  More actions

  February 2, 2013 at 4:05 pm

  #270272

  I have an need to take a list of users in a Database A with the same schema/permission/role settings and create them in another database .

  I dont want to miss out on any of the permission for an user. How can i get that?

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  February 2, 2013 at 4:51 pm

  #1583678

  check this out, read the discussion as well

  http://www.sqlservercentral.com/scripts/Permissions/76450/

  ---------------------------------------------------------------------