Copy logins/permissions | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Copy logins/permissions

Hi All,
I am adding some new logins to our testing environment which will eventually be migrated to our live server…i have found plenty on copying a login, but this doesnt appear to copy the permissions this login has been granted…any tips on how to copy the permissions too?? Ben
The permissions are stored in the database. If you use sp_help_revlogin to migrate the logins, the SID of the logins will match on both servers. You will then have proper permissions on both servers. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;246133 andhttp://www.databasejournal.com/features/mssql/article.php/1438491 link for your help. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
After adding logins(see,link given by Sathya) to the production database ,I thnk you have to manually set permissions to each users . any others hav anyother opinion??? You do any DB refresh later??
]]>