| 用途 | 受控的权限委托 |
|---|---|
| 语法 | GRANT … WITH GRANT OPTION |
| 撤销 | REVOKE GRANT OPTION ON … FROM … |
委托示例
委托示例
GRANT SELECT, INSERT, UPDATE, DELETE ON appdb.* TO 'team-lead'@'10.0.%' WITH GRANT OPTION;
REVOKE GRANT OPTION ON appdb.* FROM 'team-lead'@'10.0.%';
SHOW GRANTS FOR 'team-lead'@'10.0.%';把 GRANT OPTION 当成「代理 DBA」授权：只给限定库与明确责任人，并纳入账号审计清单。