| Data you want to alert on … | Type of Event Alert rule criteria to set … |
|---|
| When a login fails to access a database containing customer information | - Failed Logins
- Instance named SalesServer
- Database named Customers
|
| When any login performs a password change | - Security Changes
- Any SQL Server instance
- Successful Event is true
- Exclude certain event types
|
| When a non-privileged user attempts to add a login to role | - Security Changes
- Any SQL Server instance
- Successful Event is false
- Privileged User is false
- Exclude certain event types
|
| When a login other than HR01 changes the Salary table | - Data Manipulation
- Instance named HRServer
- Database object named Salary
- Login Name is not HR01
- Successful Event is true
- Exclude certain event types
|