How to audit multiple user types

At the server level, I want to audit privileged users for certain DDL, Security changes, failed logins, etc.   At the same time, how can I audit ALL failed logins on the server from any other login?  I don't want to audit every other login for DDL, security changes, etc.


No Data
  • On the Server level you have two different options. You can set up auditing for the privileged users and you can set up the general "Audited Activities". 

    So, on the Audited Activities tab you would set it up to look for "Failed Logins". 

    On the Privileged Users tab, after adding your priviliged users you can add in the checks for DDL, Security, Failed Logins, etc.