Logging
The 'security' logging category (see Description of Logging Options) logs the following information:
-
All login attempts and failures.
-
Any DDL statements that return a SECURITY_ERROR error code (see SQL Error Codes).
-
Failed attempts to access objects due to insufficient user privileges.