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