Prevent-Data-Exfiltration-in-Azure-SQL-Managed-Instance/LinkedServerauditSQLMI.sql at master · raghavender7/Prevent-Data-Exfiltration-in-Azure-SQL-Managed-Instance · GitHub

1
2
3
4
5
CREATE SERVER AUDIT [LinkedServer] TO EXTERNAL_MONITOR;
GOCREATE DATABASE AUDIT SPECIFICATION [LinkedServerMaster]FOR SERVER AUDIT [LinkedServer]ADD (EXECUTE ON OBJECT::[sys].[sp_addlinkedserver] BY [dbo]),ADD (EXECUTE ON OBJECT::[sys].[sp_addserver] BY [dbo]),ADD (EXECUTE ON OBJECT::[sys].[sp_dropserver] BY [dbo]),ADD (EXECUTE ON OBJECT::[sys].[sp_addlinkedsrvlogin] BY [dbo]),ADD (EXECUTE ON OBJECT::[sys].[sp_droplinkedsrvlogin] BY [dbo]),ADD (EXECUTE ON OBJECT::[sys].[sp_serveroption] BY [dbo]),ADD (EXECUTE ON OBJECT::[sys].[sp_setnetname] BY [dbo])WITH (STATE = ON);GO
ALTER SERVER AUDIT [LinkedServer] WITH (STATE=ON);
GO