This topic describes the system privileges in a MySQL tenant.
System privileges
| Privilege |
|
|---|---|
| ALTER | The ALTER TABLE privilege. |
| CREATE | The CREATE TABLE privilege. |
| DELETE | The DELETE privilege. |
| DROP | The DROP privilege. |
| INSERT | The INSERT privilege. |
| SELECT | The SELECT privilege. |
| UPDATE | The UPDATE privilege. |
| INDEX | The CREATE INDEX and DROP INDEX privileges. |
| CREATE VIEW | The privilege to create and delete views. |
| SHOW VIEW | The SHOW CREATE VIEW privilege. |
| CREATE USER | The CREATE USER, DROPUSER, RENAME USER, and REVOKE ALLPRIVILEGES privileges. |
| PROCESS | The PROCESS privilege. |
| SUPER | The SET GLOBAL privilege for modifying global system parameters. |
| SHOW DATABASES | The global SHOW DATABASES privilege. |
| GRANT OPTION | The GRANT OPTION privilege. |
| CREATE ROUTINE | The privilege to create procedures and functions.
NoteThis parameter is applicable only to OceanBase Database V4.2.2 and later. |
| EXECUTE | The privilege to execute procedures and functions.
NoteThis parameter is applicable only to OceanBase Database V4.2.2 and later. |
| ALTER ROUTINE | The privilege to modify and drop procedures and functions.
NoteThis parameter is applicable only to OceanBase Database V4.2.2 and later. |