CREATE USER systemselect IDENTIFIED BY 'Zbank123456'; #只给查询权限 GRANT SELECT ON szkitil.zbank_businesssystemtype TO systemselect@'%' #给查询、插入、修改、删除权限
GRANTselect
,insert,update,delete
ON szkitil.zbank_businesssystemtype TO systemselect@'%'
SHOW GRANTS FOR systemselect;