SEMv2 failed to limit many privileges #64159
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
Use the following config:
{
...
"restricted_privileges": [
"Drop",
"Config",
"File",
"Shutdown",
"BACKUP_ADMIN",
"RESTORE_ADMIN",
"PLACEMENT_ADMIN"
],
...
}
mysql> use test;
Database changed
mysql> CREATE USER 'u1'@'%' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.01 sec)
mysql> grant drop on *.* to u1@'%';
Query OK, 0 rows affected (0.01 sec)
2. What did you expect to see? (Required)
Cannot grant Drop.
3. What did you see instead (Required)
Grant Drop successfully.