This topic describes the permissions of privileged accounts and standard accounts of PolarDB .

Privileged accounts

The privileged accounts of PolarDB have the following permissions.

Account type Permission
Privileged account

SELECT, INSERT, UPDATE, DELETE, and CREATE

DROP, RELOAD, PROCESS, REFERENCES, and INDEX

ALTER, LOCK TABLES, EXECUTE, TRIGGER, and CREATE TEMPORARY TABLES

REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, and SHOW VIEW

CREATE ROUTINE, ALTER ROUTINE, CREATE USER, and EVENT

Standard accounts

The standard accounts of PolarDB have the following permissions.

Permission type Permission
Read and write

SELECT, INSERT, UPDATE, DELETE, CREATE, and EXECUTE

DROP, REFERENCES, INDEX, ALTER, and CREATE TEMPORARY TABLES

EVENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, and ALTER ROUTINE

LOCK TABLES, TRIGGER, PROCESS, REPLICATION SLAVE, and REPLICATION CLIENT

Read-only

SELECT, LOCK TABLES, and SHOW VIEW

PROCESS, REPLICATION SLAVE, and REPLICATION CLIENT

Data manipulation language (DML) only

SELECT, INSERT, UPDATE, DELETE, and LOCK TABLES

CREATE TEMPORARY TABLES, EXECUTE, TRIGGER, and EVENT

SHOW VIEW, PROCESS, REPLICATION SLAVE, and REPLICATION CLIENT

Data definition language (DDL) only

CREATE, DROP, INDEX, ALTER, and CREATE TEMPORARY TABLES

CREATE VIEW, SHOW VIEW, CREATE ROUTINE, and ALTER ROUTINE

LOCK TABLES, PROCESS, REPLICATION SLAVE, and REPLICATION CLIENT

Read-only and index SELECT, INDEX, LOCK TABLES, and SHOW VIEW