[研究] SQL Server 2019 Audit 資料庫稽核 - 登入成功或失敗紀錄檢視

[研究] SQL Server 2019 Audit 資料庫稽核 - 登入成功或失敗紀錄檢視

2020-06-15

SQL Server 2019, 2017, 2016 功能比較

https://www.microsoft.com/en-us/sql-server/sql-server-2019-comparison

稽核功能 : SQL Server 2019 >= 2017 >= 2016

點【Read the datasheet】按鈕

https://download.microsoft.com/download/2/9/0/290f991b-5971-42e5-bb2c-81f700622b2e/SQL%20Server%202019%20Editions%20Datasheet.pdf

稽核功能 : Enterprise >= Standard >= Express / Web

本篇以 SQL Server 2019 Standard 測試

(完)

相關

SQL Server 記錄檔

[研究] SQL Server 2019 Audit 資料庫稽核 - 登入成功或失敗紀錄檢視

https://shaurong.blogspot.com/2020/06/sql-server-2019-audit.html

[研究] SQL Server 2019 Audit 資料庫稽核 - 用 Trigger 觸發程序記錄歷史資料

https://shaurong.blogspot.com/2020/06/sql-server-2019-audit-trigger.html

在 SQL Server Management Studio (SSMS) 中檢視 SQL Server 錯誤記錄檔

https://docs.microsoft.com/zh-tw/sql/relational-databases/performance/view-the-sql-server-error-log-sql-server-management-studio?view=sql-server-ver15

SQL Server Audit 記錄

https://docs.microsoft.com/zh-tw/sql/relational-databases/security/auditing/sql-server-audit-records?view=sql-server-ver15

CREATE SERVER AUDIT (Transact-SQL)

https://docs.microsoft.com/zh-tw/sql/t-sql/statements/create-server-audit-transact-sql?view=sql-server-ver15

How to audit login to my SQL Server (both failed and Successful)?

https://mssqltalks.wordpress.com/2013/02/25/how-to-audit-login-to-my-sql-server-both-failed-and-successful/

SQL Server Audit 動作群組和動作

https://docs.microsoft.com/zh-tw/sql/relational-databases/security/auditing/sql-server-audit-action-groups-and-actions?view=sql-server-ver15

如何設定 MS SQL Server 稽核事件記錄

http://www.npartnertech.com/download/tech/N-Partner_MS_SQL_Server_EventLog-TW-008.pdf

SQL Server Audit 稽核

http://vito-note.blogspot.com/2013/09/blog-post.html

Various techniques to audit SQL Server databases

https://www.sqlshack.com/various-techniques-to-audit-sql-server-databases/

設定登入稽核 (SQL Server Management Studio)

https://docs.microsoft.com/zh-tw/sql/ssms/configure-login-auditing-sql-server-management-studio?view=sql-server-ver15

Configure Login Auditing (SQL Server Management Studio)

https://docs.microsoft.com/en-us/sql/ssms/configure-login-auditing-sql-server-management-studio?view=sql-server-ver15

Trigger (Transact-SQL) 相關

CREATE TRIGGER (Transact-SQL) - 中文

https://docs.microsoft.com/zH-tw/sql/t-sql/statements/create-trigger-transact-sql?view=sql-server-ver15

CREATE TRIGGER (Transact-SQL)

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql?view=sql-server-ver15

[SQL]Trigger 撰寫時要注意的小細節

https://dotblogs.com.tw/jamesfu/2014/06/20/triggersample

SQL Server CREATE TRIGGER

https://www.sqlservertutorial.net/sql-server-triggers/sql-server-create-trigger/

[MSSQL] Trigger 觸發程序初體驗 - 當某資料表被異動時自動記錄

https://blog.xuite.net/tolarku/blog/477249309-%5BMSSQL%5D+Trigger+%E8%A7%B8%E7%99%BC%E7%A8%8B%E5%BA%8F%E5%88%9D%E9%AB%94%E9%A9%97+-+%E7%95%B6%E6%9F%90%E8%B3%87%E6%96%99%E8%A1%A8%E8%A2%AB%E7%95%B0%E5%8B%95%E6%99%82%E8%87%AA%E5%8B%95%E8%A8%98%E9%8C%84

sp_trace_setfilter (Transact-SQL) 相關

sp_trace_setfilter (Transact-SQL) - 中文

https://docs.microsoft.com/zh-tw/sql/relational-databases/system-stored-procedures/sp-trace-setfilter-transact-sql?view=sql-server-ver15

sp_trace_setfilter (Transact-SQL)

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-trace-setfilter-transact-sql?view=sql-server-ver15

免費 SQL Server 稽核工具

Netwrix Auditor for SQL Server FREE COMMUNITY EDITION

https://www.netwrix.com/netwrix_change_notifier_for_sql_server.html

付費 SQL Server 稽核工具

ApexSQL 是商業付費軟體。

Auditing SELECT statements on SQL Server

https://solutioncenter.apexsql.com/auditing-select-statements-on-sql-server/

Trigger based SQL auditing

https://www.apexsql.com/sql-tools-trigger.aspx