撤销所有先前的特权，然后授予特定的新特权：
REVOKE ALL ON db.table FROM user;REVOKE ALL ON db.othertable FROM user;GRANT SELECT ON db.table TO user;GRANT SELECT, INSERT, UPDATE, DELETE ON db.othertable TO user;
撤销所有先前的特权，然后授予特定的新特权：
REVOKE ALL ON db.table FROM user;REVOKE ALL ON db.othertable FROM user;GRANT SELECT ON db.table TO user;GRANT SELECT, INSERT, UPDATE, DELETE ON db.othertable TO user;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
