PolarDB：Izin Akun

Tipe Akun

Izin

Privileged account

SELECT, INSERT, UPDATE, DELETE, dan CREATE

DROP, RELOAD, PROCESS, REFERENCES, dan INDEX

ALTER, LOCK TABLES, EXECUTE, TRIGGER, dan CREATE TEMPORARY TABLES

REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, dan SHOW VIEW

CREATE ROUTINE, ALTER ROUTINE, CREATE USER, dan EVENT

Tipe Izin

Izin

Read and write

SELECT, INSERT, UPDATE, DELETE, CREATE, dan EXECUTE

DROP, REFERENCES, INDEX, ALTER, dan CREATE TEMPORARY TABLES

EVENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, dan ALTER ROUTINE

LOCK TABLES, TRIGGER, PROCESS, REPLICATION SLAVE, dan REPLICATION CLIENT

Read-only

SELECT, LOCK TABLES, dan SHOW VIEW

PROCESS, REPLICATION SLAVE, dan REPLICATION CLIENT

Data manipulation language (DML) only

SELECT, INSERT, UPDATE, DELETE, dan LOCK TABLES

CREATE TEMPORARY TABLES, EXECUTE, TRIGGER, dan EVENT

SHOW VIEW, PROCESS, REPLICATION SLAVE, dan REPLICATION CLIENT

Data definition language (DDL) only

CREATE, DROP, INDEX, ALTER, dan CREATE TEMPORARY TABLES

CREATE VIEW, SHOW VIEW, CREATE ROUTINE, dan ALTER ROUTINE

LOCK TABLES, PROCESS, REPLICATION SLAVE, dan REPLICATION CLIENT

Read-only and index

SELECT, INDEX, LOCK TABLES, dan SHOW VIEW

PROCESS, REPLICATION SLAVE, REPLICATION CLIENT