DROP权限呢是删除对象,拥有该权限的用户可以删除指定范围内的对象(schema、表和视图)。
不能删除除这些对象之外的其他对象。
mysql> show grants for 'ut01'@'%';
+----------------------------------+
| Grants for ut01@% |
+----------------------------------+
| GRANT USAGE ON *.* TO 'ut01'@'%' |
+----------------------------------+
1 row in set (0.00 sec)
mysql> grant drop on test1.* to 'ut01'@'%';
Query OK, 0 rows affected (0.06 sec)
mysql> show grants for 'ut01'@'%';
+---------------------------------------+
| Grants for ut01@% |
+---------------------------------------+
| GRANT USAGE ON *.* TO 'ut01'@'%' |
| GRANT DROP ON `test1`.* TO 'ut01'@'%' |
+----------------