Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rootman
Starting Member
15 Posts |
 Posted - 2002-04-15 : 07:49:03
|
| Is it possible to script out all of the users and permissions for a db to then run against another db? This task takes ages, and if it could be automated in some way, it would help. The dbs are on the same server.ThanksRootman |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-04-15 : 11:40:22
|
| I usually use the Generate SQL Scripts wizard in SQL 7. Right click on a table in the source db. Click on All Tasks-->Generate SQL Scripts. Check the Script All Objects check box under Objects to Script:. On the formatting tab, uncheck the CREATE and DROP checkboxes. On the options tab, check the "Script Database Users and Database Roles" and "Script Object-Level Permissions" checkboxes. Click OK to generate the script. You should then be able to run the script in QA for the db you want to add the permissions to.Jeff BanschbachConsultant, MCDBA |
 |
|
|
|
|
|
Scripting Users and Permissions