File: oracle.rules

package info (click to toggle)
sagan-rules 1:20170725-1
  • links: PTS
  • area: main
  • in suites: buster, sid
  • size: 3,460 kB
  • sloc: makefile: 5
file content (33 lines) | stat: -rw-r--r-- 3,281 bytes parent folder | download | duplicates (2)
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
# Sagan oracle.rules
# Copyright (c) 2009-2017, Quadrant Information Security <www.quadrantsec.com>
# All rights reserved.
#
# Please submit any custom rules or ideas to sagan-submit@quadrantsec.com or the sagan-sigs mailing list
#
#*************************************************************
#  Redistribution and use in source and binary forms, with or without modification, are permitted provided that the
#  following conditions are met:
#
#  * Redistributions of source code must retain the above copyright notice, this list of conditions and the following
#    disclaimer.
#  * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the
#    following disclaimer in the documentation and/or other materials provided with the distribution.
#  * Neither the name of the nor the names of its contributors may be used to endorse or promote products derived
#    from this software without specific prior written permission.
#
#  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS AS IS AND ANY EXPRESS OR IMPLIED WARRANTIES,
#  INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
#  DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
#  SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
#  SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
#  WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE
#  USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
#
#

# 34: Audit trail: LENGTH: "351" SESSIONID:[9] "269111111" ENTRYID:[1] "1" STATEMENT:[1] "1" USERID:[8] "XXXXXXX" USERHOST:[17] "XXXX\XXXX-XXXXX" TERMINAL:[12] "XXXX-XXXXXXX" ACTION:[3] "100" RETURNCODE:[4] "1017" COMMENT$TEXT:[100] "Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=XX.XX.XX.XX)(PORT=XXXXX))" OS$USERID:[3] "Bob" DBID:[10] "4004821111" .
# 34: Audit trail: LENGTH: "358" SESSIONID:[9] "269811111" ENTRYID:[1] "1" STATEMENT:[1] "1" USERID:[14] "XXXXXXXXZZZZZZ" USERHOST:[17] "XXXX\XXXX-XXXXXX" TERMINAL:[12] "XXXXX-XXXXXX" ACTION:[3] "100" RETURNCODE:[4] "1017" COMMENT$TEXT:[100] "Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=XX.XX.XX.XX)(PORT=XXXXXX))" OS$USERID:[3] "Bob" DBID:[10] "4004827967" . 

alert any $EXTERNAL_NET any -> $HOME_NET any (msg: "[ORACLE] Authentication Failure"; content: "RETURNCODE|3a|[4] |22|1017|22|"; default_proto: tcp; default_dst_port: 1521; classtype: unsuccessful-user; parse_src_ip: 1; reference: url, wiki.quadrantsec.com/bin/view/Main/5001717; sid:5001717; rev: 4;)
alert any $EXTERNAL_NET any -> $HOME_NET any (msg: "[ORACLE] Brute force authentication failure [5/1]"; content: "RETURNCODE|3a|[4] |22|1017|22|"; after: track by_src, count 5, seconds 300; threshold: type limit, track by_src, count 1, seconds 300; xbits: set,brute_force,21600; default_proto: tcp; default_dst_port: 1521; classtype: unsuccessful-user; parse_src_ip: 1; reference: url, wiki.quadrantsec.com/bin/view/Main/5002949; sid:5002949; rev: 2;)