PolarDB for MySQL provides two account types: privileged accounts and standard accounts. Each account type grants a fixed set of MySQL privileges. Use this page to determine which privileges apply to each account type before creating accounts or assigning access.
Privileged accounts
A privileged account includes the following MySQL privileges:
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, LOCK TABLES, EXECUTE, TRIGGER, CREATE TEMPORARY TABLES, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT
Standard accounts
Standard accounts support five permission types. The privileges included in each type are listed below.
| Permission type | Privileges |
|---|---|
| Read and write | SELECT, INSERT, UPDATE, DELETE, CREATE, EXECUTE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, EVENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, LOCK TABLES, TRIGGER, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT |
| Read-only | SELECT, LOCK TABLES, SHOW VIEW, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT |
| Data Manipulation Language (DML) only | SELECT, INSERT, UPDATE, DELETE, LOCK TABLES, CREATE TEMPORARY TABLES, EXECUTE, TRIGGER, EVENT, SHOW VIEW, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT |
| Data Definition Language (DDL) only | CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, LOCK TABLES, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT |
| Read-only and index | SELECT, INDEX, LOCK TABLES, SHOW VIEW, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT |