August 14, 2007 at 8:54 am
I am trying to copy all of the permisions (db & server level) from one login to another.
Right now I'm planning on writing something to scan the databases (around 80) and look for a user related to this login then script out the user and its permissions. Get that into one file then do a search and replace on the login/user names to the new name.
Does anyone have any suggestions?
Thanks
Ken
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
August 14, 2007 at 10:54 am
Scripting is the best bet, but you shouldn't use user permissions. Use roles.
As you script things out, create a role on the new server and give it permissions and then assign the user to the role. Makes this process easier.
August 14, 2007 at 10:57 am
I've been using this script to prepare login and permission scripts for migrations from SQL 2000 to SQL 2005. http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1598
Greg
Greg
September 14, 2007 at 7:05 pm
Use this FREE tool:
IDERA.COM has free SQL tools as well as more robust tools for a fee.
What is SQLpermissions?
Idera’s SQLpermissions is a freeware tool for copying or moving logins and permissions settings across SQLservers. SQLpermissions automates the time consuming job of configuring logins and permissions on one server to match another by generating a customizable TSQL script to do this for you. SQLpermissions also offers the flexibility to move one login or a group of logins and apply permissions across all databases on the target server, or a single database.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply