Post reply

Copying Security Permission against database to another server

  • October 31, 2016 at 2:20 pm

    #318492

    Hello,

    Please suggest a best convenient method to copy the security / permission associated to a database after I restre the DB to anothrr new SQL Instance as a Fresh restore?

    Thanks.

  • October 31, 2016 at 3:19 pm

    #1909762

    Take a look at Kenneth Fishers free script session on sqlstudies.com[/url]. There you'll find scripts to script out instance- and database level permissions. You can run the generated commands on the new instance to copy all permissions.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply