Topik ini menjelaskan hak istimewa yang diberikan kepada akun istimewa dan akun standar PolarDB.
Akun istimewa
Akun istimewa PolarDB memiliki hak istimewa berikut.
|
Jenis akun |
Hak istimewa |
|
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 |
Akun standar
Hak istimewa akun standar PolarDB bergantung pada jenis hak istimewa yang ditetapkan.
|
Jenis hak istimewa |
Hak istimewa |
|
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 |