How do I execute SQL statements on the SQLConsole tab without being constrained by security rules? - Data Management

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

Prerequisites

You are a DMS administrator or DBA. For more information, see System roles.
The database instance for which you want to enable the super SQL mode is managed in Stable Change or Security Collaboration mode in DMS. For more information, see Control modes.

Background information

To improve the security and stability of database instances, DMS administrators and DBAs tend to configure security rules for database instances. For example, an unauthorized user cannot execute DML statements for database instances in a production environment on the SQLConsole tab. To apply for the required permissions, the user must submit a ticket.

However, security rules also bring inconvenience to users who are granted high-level permissions such as DMS administrators and DBAs. To allow users to execute SQL statements without being constrained by security rules, such users can execute SQL statements in super SQL mode.

Procedure

Log on to the DMS console V5.0.
In the top navigation bar, choose SQL Console > SQL Console.
Note
If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner of the DMS console and choose All functions > SQL Console > SQL Console.
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.
On the SQL Console page, click the icon in the upper-right corner. In the dialog box that appears, click OK to enable the super SQL mode.
Note
- After you enable the super SQL mode, the outside borders of the SQL Console page turn orange.
- After the super SQL mode 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, click the icon in the upper-right corner on the SQL Console page.

What to do next

In addition to the preceding operations, you may also need to perform operations such as backing up databases and exporting databases or tables for data analysis. For more information, see Export databases.