Auditing failed statements

Hi albourg -- For the select/insert/delete events, SCHEMA_OBJECT_ACCESS_GROUP should capture these events.  For schema change audit, SCHEMA_OBJECT_CHANGE_GROUP.  For the "statements causing integrity violations", I assume(!?) you are referring to referential integrity violations which could be captured using the STATEMENT_ROLLBACK_GROUP.

I would recommend creating a filter on the server audit for schemas/objects that you do not want to audit (such as the sys schema), otherwise the audit will capture a lot of noise.  Lastly, be mindful of possible performance degradation and audit log management.  Take care.