Policy checks

Get the most out of your Policy checks. This hub shows you how to work efficiently and effectively with all Policy checks whether you're working with a core policy check or a Custom policy check that is built specifically to your database.

Custom policy checks library

billingMode

Check Buffer Pool

Collection Camel Case

Collection Must Have Validator

Column Default Value

Count Rows

Create Index Count

Create Table Space

Current Schema Only

Delete Without Where

Fk Names

Identifiers Without Quotes

Index Different Tablespace

Pk Names Pg

Pk Names

Pk Tablespace

Table Column Disallow

Table Names Uppercase

timestampColumnName

varcharDataIntegrity

Varchar Max Size

Varchar Preferred

Regex Custom policy checks library

CRQLabelRequired

enumerationListContext

MultipleCreateProceduresNotAllowed

MultipleCreateTablesNotAllowed

MultipleDropsNotAllowed

MultipleGrantsNotAllowed

NoDataDmlStatements

NoDbclString

noSelectStar

NoSelect

OnlySpecificSchemasAllowed

TablesMustHaveCreateTableOnly

TablesMustHavePkOrBeNamedNpk

UppercaseTableNames

viewsMustHaveCreateReplaceViewOnly

Cassandra Regex Custom policy checks library

CreateTableMustHaveIFNOTEXIST

CreateTableMustHavePrimaryKey

CreateTableMustHaveSystemKeyFile

DynamoDB Regex Custom policy checks library

DynamoDeleteDynamoTableCheck

DynamoDeleteGlobalSecondaryIndexCheck

DynamoChangetypeAttributes

MariaDB Regex Custom policy checks library

CannotModifyUsersOrRoles

PreventLockingColumnOrIndex

MongoDB Regex Custom policy checks library

mongoCrCollectionValidatorChk

MongoCrIndexNameStdChk

mongoCreateIdxWarning

mongoNoDeleteMany

mongoNoDropCollection

mongoNoDropIndex

mongoNoMergeAggregation

mongoNoRenameCollection

mongoNoUpdateMany

Oracle Regex Custom policy checks library

CreateTableMustHaveOneGrant

CreateTableMustHavePartition

CreateTableMustHavePrimaryKey

CreateTableNoCompressAdvanced

CreateTableNoCompressFor

CreateTableWithCertainColumnRequiresSequence

CreateTableWithCertainColumnRequiresTrigger

ExecuteImmediateWarning

NoAlterUser

NoCreateRole

NoCreateUser

NoDBLinks

NoDeleteWithoutWhere

NoGrantAll

NoGrantsToPublic

NoGrantsToSystem

NoSystemSchemaChanges

Snowflake Regex Custom policy checks library

CreateObjectCheck

CreateTableMustHaveDataRetention

DatabaseNameNotAllowed

DoNotUseQaOrProdDatabases

DatabaseNameNotAllowed

NoUseDatabase

SQL Server Regex Custom policy checks library

CreateProcedureMustHaveGrantExecute

CreateTableMustHavePrimaryKey

NoAlterIndex

NoAlterProcedure

NoAlterTable

NoBulkInsert

NoCreateTable

NoCursor

NoDataDmlStatements for SQL Server

NoDeleteWithoutWhere

NoExecute

NoGrantExceptGrantExecute

NoGrantWithGrantOption

NoOpenDataSource

NoOpenRowSet

OnlyTempTableDropAllowed

Changelog checks library

ChangeDropColumnWarn

ChangeDropTableWarn

ChangesetAttributesAndValue

ChangesetAttributesSetTrueOrFalse

ChangesetCommentCheck

ChangesetContextCheck

ChangesetLabelCheck

ChangeTruncateTableWarn

CheckRunInTransactionValue

DetectChangeType

EndDelimiterExistsWhenPatternExists

FormattedSqlHeaderRequired

MaxAffectedRowsAllowedDelete

MaxAffectedRowsAllowedInsert

MaxAffectedRowsAllowedUpdate

ModifyDataTypeWarn

MongoChangetypeAttributes

OneChangePerChangeset

PrimaryKeyOnCreateTable

PatternAFollowedByPatternB

PatternAPrecededByPatternB

PatternANotFollowedByPatternB

PatternANotPrecededByPatternB

RequireChangesetIDisUUID

RollbackRequired

SQLGrantAdminWarn

SqlGrantOptionWarn

SqlGrantSpecificPrivsWarn

SqlGrantWarn

SqlRevokeWarn

SqlSelectStarWarn

SqlUserDefinedPatternCheck

UserDefinedContextCheck

UserDefinedLabelCheck

WarnOnUseDatabase

Changelog database checks library

ObjectNameMustMatch

ObjectNameMustNotMatch

OracleReservedKeywords

PostgresNonReservedKeywords

PostgresReservedKeywords

SQLServerFutureReservedKeywords

SQLServerODBCReservedKeywords

SQLServerReservedKeywords

TableColumnLimit

TableCommentCheck

TableCommentPatternCheck

Database checks library

CheckTablesForIndex

ConstraintMustExist