Data Management (DMS) provides the super SQL mode feature. After you enable this feature as a DMS administrator or a database administrator (DBA), you can execute SQL statements on the SQLConsole tab without being constrained by security rules.

Prerequisites

  • You are a DMS administrator or database administrator (DBA). For information about user roles, see System roles.

  • The database instance for which you want to enable metadata access control is managed in Security Collaboration mode. For more information, see Control modes.

Background information

To enhance the stability and security of databases, DMS administrators and DBAs may configure security rules for the databases. For example, security rules may be configured to prevent unauthorized users from executing DML statements in a production database on the SQLConsole tab. They can execute those statements only by submitting a ticket. However, security rules also cause inconvenience to members with high permissions, such as DMS administrators and DBAs.

In view of this, Data Management (DMS) provides the Super SQL Mode feature. After you enable this feature as a DMS administrator or a DBA, you can execute SQL statements on the SQLConsole tab without being constrained by security rules.

Procedure

  1. Log on to the DMS console V5.0.
    Note To switch to the previous version of the DMS console, click the 5租户头像 icon in the lower-right corner of the page. For more information, see Switch to the previous version of the DMS console.
  2. In the top navigation bar, click SQL Console. The SQL Console tab appears.
    Note If you are using the previous version of the DMS console, move the pointer over the More icon in the top navigation bar and choose SQLConsole > Single Database Query.
  3. In the Please select the database first dialog box, enter a keyword to search for a database, select the database from the search results, and then click Confirm.
  4. On the SQLConsole tab, click the Super SQL Mode icon icon in the upper-right corner. In the message that appears, click OK.
    Note
    • After you enable the super SQL mode feature, the outside borders of the SQLConsole turn orange.
    • After the super SQL mode feature is enabled, you can execute SQL statements on the SQLConsole tab without being constrained by security rules. Proceed with caution.
    • To disable the super SQL mode feature, click the Super SQL mode icon in the upper-right corner.