Use the super SQL mode

更新时间:
复制 MD 格式

Super SQL mode lets Data Management (DMS) administrators, database administrators (DBAs), and DBAs of the database instance run SQL statements on the SQL Console without being blocked by security rules. Use it to execute statements that would otherwise require a ticket — such as DELETE or CREATE INDEX — directly from the SQL Console.

Warning

When super SQL mode is active, all security rules for the database instance are bypassed. The SQL Console border turns orange to indicate elevated privileges. Disable the mode as soon as you finish.

Prerequisites

Before you begin, make sure that you have:

  • The DMS administrator role, the DBA role, or the DBA role for the specific database instance. For details, see System roles.

  • A database instance managed in Stable Change or Security Collaboration mode in DMS. For details, see Control modes.

Enable super SQL mode

  1. Log on to the DMS console V5.0.

  2. In the top navigation bar, choose SQL Console > SQL Console.

    If you use DMS in simple mode, move the pointer over the 2023-01-28_15-57-17.png icon in the upper-left corner and choose All Features > SQL Console > SQL Console.
  3. In the Please select the database first dialog box, enter a keyword to search for a database, select the database from the results, and then click Confirm.

  4. On the SQL Console page, click the 超级SQL模式 icon in the upper-right corner. In the dialog box that appears, click OK. The SQL Console border turns orange, confirming that super SQL mode is active.

Disable super SQL mode

Click the 5超级SQL模式 icon in the upper-right corner of the SQL Console page.

You may also need to perform the following operations:

  • Use DMS Data Copilot to quickly generate SQL statements, rewrite SQL statements, correct SQL faults, and generate comments. For more information, see Data Copilot (New).

  • Back up a database or export a database table for data analytics. For more information, see Database export.

References