Logging

The 'security' logging category (see 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.