Skip to main content

Include Exclude Lists for Schemas and Tables

Schema

# command line
--include-schema

#config file
schema=("<schema>", [...])

Scan only schemas matching schema; When this option is not specified, all non-system schemas in the target database will be scanned.

Multiple schemas can be selected by writing multiple -n switches. Similarly, multiple schemas can be selected by writing a tuple in the configuration file. Please note that a trailing comma is required if there is only one schema.

Also, the schema parameter is interpreted as a regular expression, so multiple schemas can also be selected by writing wildcard characters in the pattern. When using wildcards, be careful to quote the pattern if needed to prevent the shell from expanding the wildcards;

Exclude Schemas

# command line
--exlude-schema

#config file
exlude_schema=("<schema>", [...])

Do not scan any schemas matching the schema pattern. The pattern is interpreted according to the same rules as for -n. -N can be given more than once to exclude schemas matching any of several patterns. Similarly, multiple patterns can be specified with a typle in configuration file. Please note that a trailing comma is required if there is only one schema.

When both -n and -N are given, the behavior is to scan just the schemas that match at least one -n switch but no -N switches. If -N appears without -n, then schemas matching -N are excluded from what is otherwise a normal scan.

Table

# command line
--include-table

#config file
table=("<table>", [...])

Scan only tables matching pattern. Multiple tables can be selected by writing multiple -t switches. Rules are similar to -n switch.

If -n and -N switches are specified, then schemas are filtered first as per the rules and then -t is applied.

Exlude Table

# command line
--exclude-table

#config file
exclude_table=("<table>", [...])

Do not scan any tables matching pattern. Rules are similar to -T switch.

When both -t and -T are given, the behavior is to scan just the tables that match at least one -T switch but no -T switches. If -T appears without -T, then tables matching -T are excluded from what is otherwise a normal scan.