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
Post a Comment