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 |
|
dejjan
Yak Posting Veteran
99 Posts |
 Posted - 2007-11-12 : 08:18:05
|
| Hi all,is there any way to check if somebody change permissions for some user or Roles.thanks in advance |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-12 : 12:41:17
|
| only thing coming to mind is restoring (without overwriting) the database from previous backup, then comparing the two. if this question comes up often, you may want to create your own capture solution |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-12 : 23:06:38
|
| Or use auditing tool. |
|
|
|
|
|
|
How to check if some user rights are changed