Este tópico descreve os privilégios das contas privilegiadas e padrão do PolarDB.
Contas privilegiadas
A conta privilegiada do PolarDB tem os seguintes privilégios.
|
Tipo de conta |
Privilégios |
|
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 |
Contas padrão
Os privilégios da conta padrão do PolarDB dependem do tipo de privilégio atribuído.
|
Tipo de privilégio |
Privilégios |
|
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 |