使用SQL Server Log On trigger: CREATE DATABASE AuditDb GO USE AuditDb GO /* Create AuditTable */ CREATE TABLE ServerLogonHistory ( SystemUser VARCHAR ( 512 ), DBUser VARCHAR ( 512 ), SPID INT , LogonTime DATETIME ) GO /* Create LogonTrigge

使用SQL Server Log On trigger:

CREATE DATABASE AuditDb

GO

USE AuditDb

GO

/* Create AuditTable */

CREATE TABLE ServerLogonHistory

(SystemUser VARCHAR(512),

DBUser VARCHAR(512),

SPID INT,

LogonTime DATETIME)

GO

/* Create LogonTrigger */

CREATE TRIGGER Tr_ServerLogon

ON ALL SERVER FOR LOGON

AS

BEGIN

INSERT INTO AuditDb.dbo.ServerLogonHistory

SELECT SYSTEM_USER,USER,@@SPID,GETDATE()

END

GO

用戶登錄后查看監控表：

因為我們可以監控到用戶登錄SQL Server的情況，所以我們就可以限制用戶的訪問，參考下面的文章：How to prevent users from accessing SQL Server from any application or any login expect your main application & its login：http://thesqldude.com/2012/04/07/how-to-prevent-users-from-accessing-sql-server-from-any-application-or-any-login-expect-your-main-application-its-login/

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com