You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Related: SQLCM-4573, 4592 Select on sensitive columns not captured for trusted user

Steps to reproduce:

1. Open Audited database properties and add trusted user

2. In Audited activities tab, select all activities

3. In sensitive Columns tab, add tables for sensitive column access

4. Update audit settings

5. Login SQL server with the trusted user account

6. Run select queries on sensitive column tables

7. Collect audit data

8. Observe the select events are not captured

Note - Same behavior is noticed when extended events are enabled

...

 

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