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 |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2010-04-15 : 11:43:21
|
| Hi thereour permissions setup needs to be changed and we want to give a new AD user group (NewUser) the identical permissions two other users have (OldUser1, OldUser2). Is that possible to do it via script without having to go into each sql object and doing GRANT. So if OldUser1 had INSERT, DELETE permissions and OldUser2 had UPDATE permissions we would like NewUser to have INSERT, DELETE and UPDATE permissions.Is this possible to do ?THank you in advance!<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
|
|
|
|
|
move all permissions to new user group