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.
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
Log on to the DMS console V5.0.
In the top navigation bar, choose SQL Console > SQL Console.
If you use DMS in simple mode, move the pointer over the
icon in the upper-left corner and choose All Features > 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 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. The SQL Console border turns orange, confirming that super SQL mode is active.
Disable super SQL mode
Click the
icon in the upper-right corner of the SQL Console page.
What's next
After finishing your work in super SQL mode, you may need to back up or export data. See Export databases.