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 |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
 Posted - 2004-08-12 : 02:24:50
|
| HiIs there a way to determine when a user permission was updated, like a history table of some sort?Please help, urgent. |
|
|
n/a
deleted
35 Posts |
Posted - 2004-08-12 : 10:14:27
|
| In Profiler, under events there is a security group. Select those objects and you should be able to monitor what you are looking for. Then just have the trace run into a table. HTHPaul |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-08-12 : 21:53:40
|
| Hi, thanks for the tip but running the profiler on a daily basis is a no go for me. I'm looking for a system table that is updated everytime a role or user permission is updated. |
|
|
|
|
|
|
monitoring user permissions