Redgate Flyway

Redgate Regex Rules

Flyway Enterprise

RX001: DROP TABLE statement

Dialects: All

Dropping a table is likely to result in the loss of data so should be investigated before continuing.

RX002: Attempt to change password

Dialects: Oracle/PostgreSQL/TSQL

Changing passwords through a DB migration is not considered best practice

RX003: TRUNCATE statement used

Dialects: All

This operation is likely to result in a loss of data so should be investigated before continuing

RX004: DROP COLUMN statement used

Dialects: All

This operation is likely to result in a loss of data so should be investigated before continuing

RX005: GRANT TO PUBLIC statement used

Dialects: All

It is not common to access to this degree so should be investigated before continuing

RX006: GRANT WITH GRANT OPTION statement used

Dialects: All

Allows grantee to grant additional permissions and so it becomes difficult to track the scope of permissions

RX007: GRANT WITH ADMIN OPTION statement used

Dialects: All

Allows grantee to grant administrative permissions and so it becomes difficult to control the scope of permissions

RX008: ALTER USER statement used

Dialects: All

Modifies the properties of an existing user and should be investigated before continuing

RX009: GRANT ALL statement used

Dialects: All

It is not common to access to this degree so should be investigated before continuing

RX010: CREATE ROLE statement used

Dialects: All

RX011: ALTER ROLE statement used

Dialects: All

This is used to modify user accounts so should be investigated before continuing

RX012: DROP PARTITION statement used

Dialects: All

RX013: CREATE TABLE statement without a PRIMARY KEY constraint

Dialects: All

RX014: No Table Description

Dialects: TSQL

A table has been created but has no MS_Description property added

It is a good practice to include a description in the MS_Description extended property to document the purpose of a table.


Didn't find what you were looking for?