mysql给某个用户单个表权限

CREATE USER systemselect IDENTIFIED BY 'Zbank123456';
#只给查询权限
GRANT SELECT ON szkitil.zbank_businesssystemtype TO systemselect@'%'
#
给查询、插入、修改、删除权限
GRANT select,insert,update,delete ON szkitil.zbank_businesssystemtype TO systemselect@'%'
SHOW GRANTS FOR systemselect;
原文地址:https://www.cnblogs.com/weibanggang/p/11810341.html