scipt for object level permissions of the user

• dastagiri16

  Hall of Fame

  Points: 3544

  More actions

  June 12, 2011 at 1:48 am

  #252667

  hi,

  I want to transfer my database one server to another server.So is there chance to take script for object

  level permissions.Plz help me.

  Thanks & Regards

  Giri.D

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  June 12, 2011 at 9:57 am

  #1337483

  Right click the database, select "generate script" and there is an option to include permissions.

  However the easiest way to move the database is a backup and restore. That will include all permissions.