Versions Compared

Old Version 1

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 2

changes.mady.by.user Nadja Pollard

Saved on

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.

...

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

...

Excerpt
SQL Compliance Manager audits all activity on your server. Learn more > >
Idera IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources Legal