Help Center/ Distributed Database Middleware/ User Guide/ Schema Management/ Configuring a SQL Blacklist
Updated on 2024-07-30 GMT+08:00
View PDF

Configuring a SQL Blacklist

To prevent some SQL statements being executed, you can configure a blacklist and add those statements to it.

SQL statement concurrency control aims to keep DDM instances running stably even if there is a sudden increase in concurrent SQL statements.

Procedure

  1. Log in to the DDM console.
  2. In the instance list, locate the instance that you want to configure a SQL blacklist for and click its name.
  3. On the displayed page, in the navigation pane on the left, choose Schemas.
  4. In the schema list, locate the schema that you want to configure a blacklist for and click More > Configure SQL Blacklist in the Operation column.

    Figure 1 Configuring SQL blacklist

  5. In the displayed dialog box, click Edit, enter the required SQL statements or regular expressions in prefix match, full-text, and regular expression match boxes, and click OK.

    • Prefix Match: Enter SQL statements that contain keywords such as DROP or DELETE and are not allowed by the current schema.
    • Full-text Match: Enter full-text SQL statements that are not allowed by the current schema. Multiple spaces and line breaks will not be treated as if they were replaced or truncated as a single space.
    • Regular Expression Match: Enter regular expressions that are not allowed by the current schema.
    • Separate SQL statements in the blacklist with semicolons (;). The size of SQL statements for prefix match, full-text match, and regular expression match cannot exceed 1 KB, respectively.
    • If you want to clear all the SQL statements in prefix match and full-text match areas, clear them separately and click OK.

Parent topic: Schema Management