Home Forums SQL Server 2008 Security (SS2K8) Copying users, roles and permission from one db to another RE: Copying users, roles and permission from one db to another

  • December 14, 2011 at 7:35 am

    #1421294

    well, searching the scripts and articles section here on SSC will get you lots and lots of examples for scripting out users and roles, and object permissions too;

    permissions on the objects is certainly possible, so you plan on deploying the script agaisnt a standardized database schema, so all the expected objects exist?

    what would happen if you generate a script for, say SELECT permissions on a specific view, but the view doesn't exist int he database?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!