Page History
...
Data Type | Events Audited | Description |
---|---|---|
Logins |
| Audits login activity if an access check is performed and the event status is recorded (success or failure) at the server level |
Administration |
| Audits common administrative tasks on the SQL Server instance |
Security |
| Audits all SQL security model activity |
Database Definition (DDL) |
| Audits create, drop, and alter operations performed on SQL Server objects, database objects, and schema object |
DML | Object permissions | Audits common database operations, such as:
|
Select | SELECT | Audits all SELECT statements executed on database table |
Privileged User | All | Audits 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 defined | All | Audits 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 audits all activity on your server. Learn more > > IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |
...