Can Audit DB really audit who views what data (SELECT statements)?
Yes. Audit DB captures SELECT commands that fail to meet permission checks and those that are successfully executed. Audit DB stores the actual text of all SELECT commands in the Audit DB Repository. And by using the Audit DB reporting interface you will be able to view the following information: Session ID, Date & Time, the user (SQL username and NT username), Client Host Name, Login Name, Application Name, Server, Database, Tables & Views, OS user and the actual text of the SELECT command.
Related Questions
- Since the Data Call instructions for capturing exposure data and developing the audit file specifications do not require a premium to be reported, is the premium amount required for audit purposes?
- Can Audit DB really audit who views what data (SELECT statements)?
- Does ApexSQL Audit audit SELECT statements?
