Este tema describe los privilegios que se otorgan a las cuentas privilegiadas y estándar de PolarDB.
Cuentas privilegiadas
Una cuenta privilegiada de PolarDB tiene los siguientes privilegios.
|
Tipo de cuenta |
Privilegios |
|
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 |
Cuentas estándar
Los privilegios de una cuenta estándar de PolarDB dependen del tipo de privilegio asignado.
|
Tipo de privilegio |
Privilegios |
|
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 |