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 |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2008-02-08 : 10:25:43
|
| Using Management Studio how do you script only user and object permissions? I don't want to script the corresponding "Create" statements for each object, only their permissions.Thanks, Dave |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-08 : 22:00:02
|
| Set script permission to true and choose to script user only. |
 |
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2008-02-11 : 10:23:53
|
| That won't script the object permissions. |
|
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2008-02-11 : 23:15:31
|
| The problem appears to be either a bug or very poor code on the part of Microsoft. When scripting object and user permissions with SP1, the options available are different then with SP2. In SP1 you only have the option of selecting CREATE or DROP statements. In SP2 you have the ability to select neither CREATE or DROP and script the permissions only. The problem I am ecountering is trying to script permissions for 2,000 to 3,000 objects (tables/views/stored procedures) and users/roles. When scripting permissions for just over 2,000 objects and users/roles the process does eventually complete after about 50 minutes. With 3,000 objects the scripting takes well over one hour to complete. Unfortunately I need to contact Microsoft to see if there is any way to speed things up. I doubt there is.Dave |
|
|
|
jordanam
Yak Posting Veteran
62 Posts |
Posted - 2008-03-13 : 10:40:35
|
| Curious, did you ever resolve this? |
|
|
|
|
|
|
How to script user & object permissions in 2005