728x90
특정 사용자에 대한 로그인 감사 기록 남기기
/****** Object: Audit [ServerAuditSpecification-20201106-140647] Script Date: 2020-11-06 오후 2:14:26 ******/
CREATE SERVER AUDIT [ServerAuditSpecification-20201106-140647]
TO APPLICATION_LOG
WITH
( QUEUE_DELAY = 1000
,ON_FAILURE = CONTINUE
,AUDIT_GUID = '298f9952-679f-41d9-9fef-1be263f4ddf6'
)
WHERE ([server_principal_name]='도메인\계정' OR [server_principal_name]='도메인\계정')
ALTER SERVER AUDIT [ServerAuditSpecification-20201106-140647] WITH (STATE = ON)
GO728x90