假设用户没有当前权限,则可以执行以下操作
GRANT SELECT, INSERT, DELETE ON db_Payroll.tb_Users TO RestrictedUser@'%'
GRANT SELECT, INSERT, DELETE ON db_Payroll.tb_Employees TO RestrictedUser@'%'
根据您希望授予用户的特权,您可以更改SELECT, INSERT, DELETE
为其他内容,例如ALL PRIVILEGES
。
之后,请记住清除特权以使其生效。
FLUSH PRIVILEGES;