SQL Server Logging Denied Access -


i wondering if knew if logging capabilities of sql server extended tracking user attempts query information on not have access. example, if user attempts query object or schema on lacks permissions, logs capture attempt when receives error similar below:

msg 229, level 14, state 5, procedure sproc, line 1 execute permission denied on object 'sproc', database 'db', schema 'schema'. 

any advice appreciated, in advance

there event called user error message under errors , warnings section. can log event


Comments

Popular posts from this blog

javascript - DIV "hiding" when changing dropdown value -

Does Firefox offer AppleScript support to get URL of windows? -

android - How to install packaged app on Firefox for mobile? -