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 |
|
dpais
Yak Posting Veteran
60 Posts |
 Posted - 2009-06-16 : 10:33:27
|
| Is there a script to copy user level permissions from one user to another so that we dont have to go through the tedious process of checking off all those boxes ??what i'm trying to do is troubleshoot a security issue with a test login account .... problem is that when i have to clone permissions from the users account to the test account it takes ages ...is there a script available to do this ?thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dpais
Yak Posting Veteran
60 Posts |
Posted - 2009-06-17 : 07:45:02
|
| Thanks Tara : I think i should have explained better.I have approx 12 databases with about 6 to 10 roles setup in each database. So i am looking for a script to copy roles from one user to another .... thanks again. |
 |
|
|
|
|
|
QUESTION ON PERMISSIONS