MySQL权限篇讨论之权限收回之级联影响

比如，A把权限X授予了B（with grant option），B再把X权限授予了C。

那么A把B的X权限收回之后，C的X权限是否受到影响？答案是不影响。

D:\temp>mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.7.11-log MySQL Community Server (GPL)


Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> show grants for 'ut01'@'%';
+----------------------------------+
| Grants for ut01@%                |
+----------------------------------+
| GRANT USAGE ON *.* TO 'ut01'@'%' |
+----------------------------------+
1 row in set (0.00 sec)


mysql> create user 'ut02'@'%';
Query OK, 0 rows affected (0.09 sec)


mysql> alter user 'ut02'@'%' identified by '20127163';
Query OK, 0 rows affected (0.38 sec)


mysql> show grants for 'ut02'@'%';
+----------------------------------+
| Grants for ut02@%                |
+----------------------------------+
| GRANT USAGE ON *.* TO 'ut02'@'%' |
+----------------------------------+
1 row in set (0.00 sec)


mysql>

授予ut01@%某个权限：

mysql> grant select on test.t_area to 'ut01'@'%' with grant option;
Query OK, 0 rows affected (0.04 sec)


mysql> show grants for 'ut01'@'%';
+-----------------------------------------------------------------+
| Grants for ut01@%                                               |
+-----------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'ut01'@'%'                                |
| GRANT SELECT ON `test`.`t_area` TO 'ut01'@'%' WITH GRANT OPTION |
+-----------------------------------------------------------------+
2 rows in set (0.00 sec)


mysql>