Authentication in SQL Server identifies the caller through supported identity choices. My GDPR series considered those choices alongside access controls.
SQL SERVER – GDPR Features and Operational Responsibilities
GDPR Compliance concerns how an organization processes personal data. Reader questions prompted my series about the database controls that can help.
SQL Server Audit: Tracking Who Read or Changed Sensitive Tables
Configure SQL Server Audit for reads and changes, inspect file records by user and time, and plan retention and target failures.
Auditing SELECT Statements on Sensitive Tables
Auditing SELECT statements on sensitive tables needs a narrow database audit, protected files, volume checks, and active review.