Migrating permissions | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Migrating permissions

Hi guys,
how it could be done when we have two databases need same permissions .one we already created and need to create same on other database.that means need to migrate all users and permissions from one database to other . SRJ2005
You can manually script all the permissions from the older database and then run the script on the new database. Another option would be to use a third-party tool, such as SQL Compare from www.red-gate.com.
Such a tool makes it easy to move permissions from one database to another. ——————————–
Brad M. McGehee, SQL Server MVP
Script from the following link will be useful… http://www.sql-server-performance.com/bm_object_permission_scripts.asp
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.