将当前数据库的表role_modules 的select权限赋予给用户uwangq:
GRANT SELECT ON role_modules TO uwangq@'%' IDENTIFIED BY "uwangq";
FLUSH PRIVILEGES;
将当前数据库的表role_modules 的select权限从用户uwangq上撤销:
REVOKE SELECT ON role_modules FROM uwangq@'%' IDENTIFIED BY "uwangq";
FLUSH PRIVILEGES;