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
http://www.sqlbrad.com

Script from the following link will be useful… http://www.sql-server-performance.com/bm_object_permission_scripts.asp
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>