PolarDB：帳號許可權

帳號類型

許可權

高权限账号

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

權限類別型

許可權

读写

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

只读

SELECT、LOCK TABLES、SHOW VIEW

PROCESS、REPLICATION SLAVE、REPLICATION CLIENT

仅DML

SELECT、INSERT、UPDATE、DELETE、LOCK TABLES

CREATE TEMPORARY TABLES、EXECUTE、TRIGGER、EVENT

SHOW VIEW、PROCESS、REPLICATION SLAVE、REPLICATION CLIENT

仅DDL

CREATE、DROP、INDEX、ALTER、CREATE TEMPORARY TABLES

CREATE VIEW、SHOW VIEW、CREATE ROUTINE、ALTER ROUTINE

LOCK TABLES、PROCESS、REPLICATION SLAVE、REPLICATION CLIENT

只读+索引

SELECT、INDEX、LOCK TABLES、SHOW VIEW

PROCESS、REPLICATION SLAVE、REPLICATION CLIENT