sql-sniffer

Given a string, will return an array of recognize phrases (if present within that string) that pertain to certain System, Data Dictionary, Anonymous Block, DML or DDL database function.

Usage

A simple watchdog for sensitive Database commands and transactions.

Installation

npm install sql-sniffer

Recognized Phrase Patterns:

All patterns are case insensitive

Key:

symbol	function
*	any one of the folowing characters or combos--> ; ' " -- \ /* '
...	any white space between
..W..	any white space and/or words between
C	any "\w" character

Patterns:

Category: Removal

pattern	a.k.a.
*...truncate...table	* truncate table
*...drop...table	* drop table
*...drop...procedure	* drop procedure
*...drop...package	* drop package
*...drop...function	* drop function
*...drop...index	* drop index
*...drop...bitmap...index	* drop bitmap index
*...drop...unique...index	* drop unique index
*...drop...materialized...view	* drop materialized view
*...drop...view	* drop view
*...drop...trigger	* drop trigger
*...drop...type	* drop type
*...delete...from	* delete from
*...purge...table	* purge table
*...purge...recyclebin	* purge recyclebin

Category: DDL

pattern	a.k.a.
*...create...or...replace	* create or replace
*...create...table	* create table
*...alter...table	* alter table
*...create...procedure	* create table
*...create...package	* create package
*...create...function	* create function
*...create...index	* create index
*...alter...index..W..rebuild	* alter index [TEXT HERE] rebuild
*...alter...index..W..rename	* alter index [TEXT HERE] rename
*...create...bitmap...index	* create bitmap index
*...create...unique..index	* create unique index
*...create...materialized view	* create materialized view
*...create...view	* create view
*...alter...view	* alter view
*...create...trigger	* create trigger
*...create...type...as	* create type as

Category: System

pattern	a.k.a.
*...alter...system...set	* alter system
*...shutdown...normal	* shutdown normal
*...shutdown...immediate	* shutdown immediate
*...shutdown...transactional	* shutdown transactional
*...shutdown...abort	* shutdown abort

Category: DML

pattern	a.k.a.
*...update...set	* update set
*...insert...into	* insert into
*...insert...all...into	* insert all into
*...merge...into..W..using	* merge into [TEXT HERE] using

Category: Anonymous Block

pattern	a.k.a.
*...begin..W..;...end	begin [TEXT HERE]; end
*...sys.C	sys.[TEXT HERE]
*...execute immediate	execute immediate
*...&&	&&

Category: Data Dictionary

pattern	a.k.a.
v$	v$
from..W..all_	from [TEXT HERE] all_
from..W..dba_	from [TEXT HERE] dba_
from..W..user_	from [TEXT HERE] user_

Category: Additional Patterns

pattern	a.k.a.
1...=...1...--	1=1--
1...=...1...#	1=1#
1...=...1.../*	1=1/*
'...1...'...=...'...1...--	'1'='1--
admin...'...--	admin'--
admin...'...#	admin'#
admin...'.../*	admin'/*