/etc/prelude-lml/ruleset/ms-sql.rules is in prelude-lml-rules 4.1.0-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 | #FULLNAME: Microsoft SQL
#VERSION: 1.0
#DESCRIPTION: SQL Database from Microsoft. The rules included here were developed using Microsoft SQL Server 2000 SP3a events collected using NTSysLog.
#####
#
# Copyright (C) 2003 G Ramon Gomez <gene at gomezbrothers dot com>
# Tyco Fire and Security GTS (www.tycofireandsecurity.com)
# All Rights Reserved
#
# This file is part of the Prelude-LML program.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2, or (at your option)
# any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License along
# with this program; if not, write to the Free Software Foundation, Inc.,
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
#
#####
#DESCRIPTION:Attempt failed to login to MS-SQL instance as generic user
#CATEGORY:Authentication
#LOG:Nov 24 14:45:58 testdb.itg.sac.tfs mssqlserver[info] 17055 18456 : Login failed for user 'probe'.
regex=(mssql.+)\[\w+\] \d+ \d+ : Login failed for user '(?!sa)(.+)'; \
classification.text=Database user login; \
id=1000; \
revision=2; \
analyzer(0).name=SQL Server; \
analyzer(0).manufacturer=Microsoft; \
analyzer(0).class=Database; \
assessment.impact.severity=medium; \
assessment.impact.completion=failed; \
assessment.impact.type=user; \
assessment.impact.description=An attempt was made to login to MS-SQL instance $1 using account $2; \
target(0).user.user_id(0).type=target-user; \
target(0).user.user_id(0).name=$2; \
target(0).process.name=$1; \
last
#DESCRIPTION:Attempt failed to login to MS-SQL instance as admin user
#CATEGORY:Authentication
#LOG:Nov 24 14:45:58 testdb.itg.sac.tfs mssqlserver[info] 17055 18456 : Login failed for user 'sa'.
regex=(mssql.+)\[\w+\] \d+ \d+ : Login failed for user 'sa'; \
classification.text=Database admin login; \
id=1001; \
revision=2; \
analyzer(0).name=SQL Server; \
analyzer(0).manufacturer=Microsoft; \
analyzer(0).class=Database; \
assessment.impact.severity=medium; \
assessment.impact.completion=failed; \
assessment.impact.type=admin; \
assessment.impact.description=An attempt was made to login to MS-SQL instance $1 as sa; \
target(0).user.user_id(0).type=target-user; \
target(0).user.user_id(0).name=sa; \
target(0).process.name=$1; \
last
|