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 |
|
chih
Posting Yak Master
154 Posts |
 Posted - 2012-01-10 : 17:02:28
|
| Hi All,I have a very strange case.A role normally has permissions (Select/Insert/Update) to one table. But somehow, those permissions are all disappeared.Is there any log I can look to find the reason?cheers |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2012-01-11 : 08:42:54
|
| No, there is not. If you wanted to capture information like that you would need to do something like set up your own audit table and populate it from a DDL trigger.As to why that role lost permissions to that table, perhaps the table (or role) was dropped and recreated?Be One with the OptimizerTG |
 |
|
|
|
|
|
Where to find the log who revoke the permission