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 |