Versions Compared

Key

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

...

Data TypeEvents AuditedDescription
Logins
  • Successful logins
  • Logouts
  • Failed logins Impersonation
Audits login activity if an access check is performed and the event status is recorded (success or failure) at the server level
Administration
  • Backups Restores
  • DBCC
  • Change server settings
  • Alter trace Database operation
Audits common administrative tasks on the SQL Server instance
Security
  • Add login
  • Add role
  • Grant, Revoke, Deny
  • Change role password
  • Change login properties
  • Change owner
Audits all SQL security model activity
Database Definition (DDL)
  • Derived permission
  • SQL statement permission
  • Database access
Audits create, drop, and alter operations performed on SQL Server objects, database objects, and schema object
DMLObject permissions

Audits common database operations, such as:

  • UPDATE
  • INSERT
  • DELETE
SelectSELECTAudits all SELECT statements executed on database table
Privileged UserAllAudits all privileged user activity at any level
If the privileged user is also a trusted user , SQL Compliance Manager continues to audit this user because of its elevated privileges. For example, a service account that is a member of the sysadmin fixed SQL Server role will continue to be audited even though the account is designated as trusted.
User definedAllAudits all custom events generated using the sp_trace_generateevent stored procedure

...

This flexibility allows you to achieve precise and granular compliance. For example, you can configure different audit settings for multiple databases hosted on a single registered SQL Server instance.



Scroll pdf ignore
SQL Compliance Manager monitor, audit and alert on SQL user activity and data changes.
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
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

...