• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

capture failed CREATE attempts

if there is an attempt to create an object but fails, - how can we capture who/when/what was trying to create with insufficient permissions?

thanks
0
anushahanna
Asked:
anushahanna
1 Solution
 
lcohanDatabase AnalystCommented:
You can capture that in profiler as per attached screenshot. Because this IS an error it won't be visible in a DDL trigger action and not in the SQL Log as well.
Profiler.png
0
 
anushahannaAuthor Commented:
thanks lcohan.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now