Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Permission name | Description |
ALTER | Modify the structure of tables in the database, including permissions for altering table fields, adding table fields, deleting table fields, as well as creating and removing table indexes. |
ALTER ROUTINE | Privileges to alter routines such as stored procedures and functions. |
CREATE | Privileges to create new objects such as databases, tables, views, stored procedures, and functions. |
CREATE ROUTINE | Privileges to create routine objects such as stored procedures and functions. |
CREATE TEMPORARY TABLES | Privilege to create temporary tables. |
CREATE VIEW | Privilege to create view objects. |
DELETE | Privilege to delete data from specified tables. |
DROP | Privilege to drop objects such as databases, tables, views, stored procedures, and functions. |
EVENT | Privilege to create, modify, and delete events. |
EXECUTE | Privilege to execute existing objects such as stored procedures and functions. |
INDEX | Privilege to create and delete indexes. |
INSERT | Privilege to insert/write new data into tables. |
LOCK TABLES | Privilege to lock specified data tables for read/write operations. |
REFERENCES | Privilege to create or drop foreign key constraints within the current database. |
RELOAD | Privilege to reload some configuration files of the system, restart or shutdown the database, and perform other operations. |
REPLICATION CLIENT | Privilege to view and manage the status and parameters of replication processes. |
REPLICATION SLAVE | Privilege to replicate data from the MASTER server. |
SELECT | Privilege to query data from specified tables. |
SHOW DATABASES | Privilege to display all databases within the current database server. |
SHOW VIEW | Privilege to display views. |
SYSTEM_VARIABLES_ADMIN | Privilege to modify system variables. |
TRIGGER | Privilege to create and manage triggers. |
UPDATE | Privilege to update data in specified tables. |

フィードバック