Page History
...
When you update audit settings to audit privileged user activities, these changes are not applied until the SQL trace is refreshed. The SQL trace is refreshed when the SQL Compliance Manager Agent sends the trace files to the Collection Server. To ensure an immediate application of your new audit settings, click Update Audit Settings Now on the Agent menu.
Available actions
...
Allows you to select one or more privileged users to audit. You can select privileged users by login name or by membership to a fixed server role.
...
Allows you to remove the selected SQL Server login or fixed server role from the list of audited privileged users. When you remove the login or role, the SQL Compliance Manager Agent no longer collects events recorded for that login or the role members.
Note | ||
---|---|---|
| ||
Privileged Users selected at Server-level auditing are pre-selected and disabled for selection. These Privileged Users can be removed only at Server-level Privileged Users auditing. |
Available fields
Server-Level Privileged Users
Lists the audited privileged users configured at Server-level. These users can only be edited at Server-level Privileged Users.
Privileged users and roles to be audited
Lists the audited privileged users by login name or fixed server role. If you are auditing privileged users in a fixed server role, the SQL Compliance Manager Agent collects activities executed by all members of the selected role.
...
- Logins
- Logouts
- Failed logins
- Security changes
- Administrative actions
- Database definition (DDL)
- Database modification (DML)
- Database SELECT operations
- User-defined events
- Filter events based on the access check
Note | ||
---|---|---|
| ||
Audited activities configured at Database-level auditing are automatically pre-selected and disabled for selection for Privileged Users added at Database level auditing. Users must edit changes at the Database level Auditing Activities tab to disable these settings. |
Capture SQL statements for DML and SELECT activity
...
The Add Users window is accessed by clicking Add on on the Privileged User Auditing tab while viewing Registered SQL Server Properties. Use this window to include selected login accounts and roles as privileged. Added logins/roles may be removed by selecting the item in the Privileged User Auditing tab , and then click clicking Remove.
...