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 |
|
denis_the_thief
Aged Yak Warrior
596 Posts |
 Posted - 2013-05-28 : 11:06:58
|
| Is there a query to find out when a User's access to a Database changed. I was looking at sys.database_role_members but it has not Data columns. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-28 : 16:56:33
|
| You might be able to look at the default trace - see response by Jonathan Kehayias in this htread: http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/e41ca3ff-63b3-46ff-b389-3d05c7b141b1/ |
 |
|
|
|
|
|
Query to see when a Users access to a DB changed