DMC provides preset SQL management specifications for MySQL and TDSQL database types, including the SQL Window Standards and SQL Review Standards. It also supports custom SQL management specifications, allowing users to add, modify, and delete specifications. After an instance is bound to an SQL management specification, SQL operations in the SQL window and data changes will be regulated according to the bound specification, enhancing the standardization of SQL operations and ensuring database security.
The preset specification names are MySQL (Default) and TDSQL for MySQL (Default).
Prerequisites
The operating user should hold the DMC administrator role.
2. In the top menu bar, select System Management > Management Standard.
3. View the management specifications list.
Database type: The database types applicable to the management specification, including MySQL and TDSQL.
Associated Instance Quantity: The number of instances associated with the management specification. Hover the mouse pointer over
to display the associated instance IDs.
Set as Default: MySQL and TDSQL database types should each have one management specification set as default.
Edit: Click Edit to enter the Management Standard Details page, where you can view the details of SQL Window Standards and SQL Review Standards, as well as enable or disable specific specifications.
Preset management specifications are view-only and do not support modifying the status of specific specifications.
MySQL default: SQL Window Standards
MySQL default: SQL Review Standards
TDSQL default: SQL Window Standards
TDSQL default: SQL Review Standards
Delete: Click Delete to remove an added management specification.
Only management specifications with no associated instances can be deleted. Preset management specifications and those with associated instances cannot be deleted.
Adding Management Standards
1. On the Management Standard page, click Add at the top.
2. In the pop-up dialog box, select the database type, enter the specification name, and click Submit.
3. In the Operation column corresponding to the specification, click Edit.
4. On the Management Standard Details page, select the SQL Window Standards and SQL Review Standards tabs to view and enable specific specifications.
Related Operations
After a management specification is associated with an instance, SQL operations related to the instance’s SQL window and data changes will comply with the constraints defined in the bound management specification. For details on how to bind a management specification to an instance, seeEditing Instance Management Specification (Administrator).
