July 22, 2008 at 7:23 am
Hi guys
I have a question, is there a way to audit permission denied results from statements done in my database so I can see which users and connections attempted to make any DML statement and it resulted ond a permission denied on object?
I've tried the Security Audit events in SQL Profiler but I don't know if this shows them or how to identify them
Any help is appreciated.
Thanks.
July 22, 2008 at 9:25 am
You probably want the "Audit Schema Object Access event" which records both sucessful and unsucessful attempts and then filter out the sucessfull events.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 23, 2008 at 5:42 am
Thanks I'll check it out
July 23, 2008 at 7:40 am
Let us know how it works out.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 23, 2008 at 11:06 am
It worked, just have to add the Success column to check that if permission is denied value = 0, else value = 1.
July 23, 2008 at 12:27 pm
Great, glad it worked out fo ryou.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply