How to make a Custom Rule for a SQL Database
Here is an example for how to make a Custom Rule "Every table name must start with 'tbl'":
- Script out the database
-
- Figure: Generate script for the database to a script file
- Run Code Auditor and go to "Select Job" page
-
- Figure: Select 'a sample SQL Script project'
- Select files to scan
-
- Figure: Select files
- Adding a new rule
-
- Figure: Click Add button to create a new rule
-
- Figure: Enter new rule name
-
- Figure: Enter rule URL and note
-
- Figure: Enter File Filter and Search pattern (Regex)
- Rule Processing
-
- Figure: Click Start button to start Rule Processing
- Rule Result
-
- Figure: Rule Result Page - show you a summary of the rules that passed and failed
- Rule Report
-
- Figure: Rule Report - Show you the details of the rules that passed and failed
- More details and screen shots on Creating New Rule