Post reply

Getting same Roles to producion database

  • January 7, 2014 at 3:30 pm

    #302410

    Hi,

    I have the same database in both dev and production environment. I want to back up the production database to the development. But the users have read only permissions in production environment how can I get same roles as it is in dev (read&right) environment to the users.

    I read something role deployment to do that. Please let me know how can we do this?

  • January 8, 2014 at 12:27 am

    #1678321

    Script the permissions from dev before you restore (semi-manual), run the script that recreates the permissions after the restore.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 8, 2014 at 6:28 am

    #1678396

    Thank you.

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

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