Post reply

permissions

  • November 14, 2012 at 2:27 pm

    #393603

    I am doing refresh from PROD to DEV.

    I need take a permissions backup script for a database in DEV before restoring from PROD.

    and restore the permissions back in DEV, when the refresh is done.

    So, I need help in scripting out permissions for a database.

    Please don't say sp_help_revlogin: It gives list out all the logins on a server.

  • November 14, 2012 at 2:28 pm

    #1559128

    Duplicate post see here http://www.sqlservercentral.com/Forums/Topic1384732-391-1.aspx

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

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

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