This topic describes the privileges granted to PolarDB privileged and standard accounts.
Privileged accounts
A PolarDB privileged account has the following privileges.
|
Account type |
Privileges |
|
Privileged Account |
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
The privileges of a PolarDB standard account depend on its assigned privilege type.
|
Privilege type |
Privileges |
|
Read/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 |
|
DML Only |
SELECT, INSERT, UPDATE, DELETE, LOCK TABLES CREATE TEMPORARY TABLES, EXECUTE, TRIGGER, EVENT SHOW VIEW, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT |
|
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 + Index |
SELECT, INDEX, LOCK TABLES, SHOW VIEW PROCESS, REPLICATION SLAVE, REPLICATION CLIENT |