Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For example, when a suspicious event is discovered, you can be notified by email so you can immediately diagnose and resolve the issue. You can also configure IDERA SQL Compliance Manager to write a custom message to the application event log so you have an ongoing record.

...

Use the following examples to help you identify the alert criteria you need to define in the corresponding Event Alert rule to monitor a specific action.

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



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 

...

SQL Compliance Manager audits all activity on your server. Learn more > >

...

Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...