账号权限列表
|
账号类型 |
授权类型 |
权限 |
||||
|
高权限账号 |
– |
ALTER,ALTER ROUTINE,CREATE,CREATE VIEW,CREATE ROUTINE,CREATE USER,CREATE TEMPORARY TABLES,DELETE,DROP,EVENT,EXECUTE,INDEX,INSERT,LOCK TABLES,PROCESS,RELOAD,REFERENCES,REPLICATION SLAVE,REPLICATION CLIENT,SELECT,SHOW VIEW,TRIGGER,UPDATE |
||||
|
普通账号 |
只读 |
LOCK TABLES,PROCESS,REPLICATION SLAVE,REPLICATION CLIENT,SELECT,SHOW VIEW |
||||
|
读写 |
ALTER,ALTER ROUTINE,CREATE,CREATE TEMPORARY TABLES,CREATE VIEW,CREATE ROUTINE,DELETE,DROP,EVENT,EXECUTE,INSERT,INDEX,LOCK TABLES,PROCESS,REFERENCES,REPLICATION SLAVE,REPLICATION CLIENT,SELECT,SHOW VIEW,TRIGGER,UPDATE |
|||||
|
仅DDL |
ALTER,ALTER ROUTINE,CREATE,CREATE VIEW,CREATE TEMPORARY TABLES,CREATE ROUTINE,DROP,INDEX,LOCK TABLES,PROCESS,REPLICATION SLAVE,REPLICATION CLIENT,SHOW VIEW |
|||||
|
仅DML |
CREATE TEMPORARY TABLES,DELETE,EVENT,EXECUTE,INSERT,LOCK TABLES,PROCESS,REPLICATION SLAVE,REPLICATION CLIENT,SELECT,SHOW VIEW,TRIGGER,UPDATE |
|||||
内容没看懂？ 不太想学习？想快速解决？ 有偿解决： 联系专家
阿里云企业补贴进行中： 马上申请
腾讯云限时活动1折起，即将结束： 马上收藏
同尘科技为腾讯云授权服务中心。
购买腾讯云产品享受折上折，更有现金返利:同意关联，立享优惠
转转请注明出处：https://www.yunxiaoer.com/156232.html
