Configuring a SQL Blacklist

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.
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.
   Note

   • 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.