Data Management (DMS) provides the super SQL mode feature. Upon you enable this feature as a DMS administrator or a database administrator (DBA), all SQL statements that you execute on the SQLConsole tab are executed directly without the limit of security rules.

Prerequisites

  • You are a database administrator (DBA) or a DMS administrator. For more information about user roles, see System roles.
  • An instance is in Secure Collaboration mode.

Background information

To enhance the stability and security of databases, DMS administrators and DBAs usually configure security rules for the databases. For example, a security rule is configured to prevent unauthorized users to execute Data Manipulation Language (DML) statements in a production database in the SQLConsole. 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. If you enable this feature as a DMS administrator or a DBA, all SQL statements that you execute on the SQLConsole tab are executed directly without the limit of security rules.

Procedure

  1. Log on to the DMS console.
  2. In the top navigation bar, move the pointer over the All functions icon and choose SQLConsole > Single Database query.
    Note In the left-side navigation pane of the DMS console, you can double-click the database that you want to query to go to the SQLConsole tab.
  3. Select the database that you want to query from the drop-down list or enter a keyword in the field to search for the database. After you select the database, click Confirm.
  4. On the SQLConsole tab, click the Super SQL mode icon in the upper-right corner. In the message that appears, click OK.
    Then, the outside borders of the SQLConsole turn orange. This indicates that the Super SQL Mode feature is enabled. The SQL statements that you enter in the SQLConsole are executed directly.
    Note Pay attention to the operation risks.
    Enable super SQL mode feature

    To disable the Super SQL Mode feature, click the Super SQL mode icon.