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

  • In that case sys.database_principals and sys.database_role_members has all the metadata you need to build the commands that can add the Database Roles and Database Users to another database.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato