Auditing permission changes

What I would like is to log all the permission changes into a table.
Like if a developer changed a permission to a view or a table or any
other object it would get logged into a table. Also logging database
and server level permission changes like some one giving some one a
dbowner access. Any suggessions?
Thank You,
-Pranay
> What I would like is to log all the permission changes into a table.
> Like if a developer changed a permission to a view or a table or any
> other object it would get logged into a table. Also logging database
> and server level permission changes like some one giving some one a
> dbowner access. Any suggessions?
Check the SQL Profiler in Books OnLine, specifically "Security Audit Event
Classes" topic.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
|||Hi Dejan,
Now I am running a trace. But the trace captures events like temp
index creations. I tried not like 'Create Index #' in the text data
but that filter did not work. It is still capturing temp index
creations. I filtered out temp db so the temp table creations are not
captured now. Any suggessions on removing temp index creations?
|||> Now I am running a trace. But the trace captures events like temp
> index creations. I tried not like 'Create Index #' in the text data
> but that filter did not work. It is still capturing temp index
> creations. I filtered out temp db so the temp table creations are not
> captured now. Any suggessions on removing temp index creations?
Use % wildchar, not # - 'Create Index%' should work.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com