how to store DB roles before restoring db

• SQlLogic

  SSCrazy Eights

  Points: 9686

  More actions

  March 1, 2013 at 6:14 am

  #269147

  Hi guys

  is there anyway we can script out or store the database roles and permission before we restore that DB.

  If anyone can help me out with this

  Thanks And Happy Fri

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  March 1, 2013 at 8:45 am

  #1592419

  If you create the logins with the right SID then you will not have a problem with permissions and roles when restoring the DB.

  You can get the SID from sysusers.

  SELECT @sid

  FROM SysUsers

  WHERE Name=<Login Name>

  Keep in mind that the Windows authentication user will not have a DB SID

  -Roy