MySQL如何查看用户授予的权限(2)

3：那么我们来创建一个测试账号test,授予表层级的权限.如下所示：

?

1. mysql>?drop?user?test;?
2. Query?OK,?0?rows?affected?(0.00?sec)?
3. ??
4. mysql>?flush?privileges;?
5. Query?OK,?0?rows?affected?(0.00?sec)?
6. ??
7. mysql>?grant?all?on?MyDB.kkk?to?test@'%'?identified?by?'test';?
8. Query?OK,?0?rows?affected?(0.01?sec)?
9. ??
10. mysql>??
11. ??
12. mysql>?show?grants?for?test;?
13. +-----------------------------------------------------------------------------------------------------+?
14. |?Grants?for?test@%???????????????????????????????????????????????????????????????????????????????????|?
15. +-----------------------------------------------------------------------------------------------------+?
16. |?GRANT?USAGE?ON?*.*?TO?'test'@'%'?IDENTIFIED?BY?PASSWORD?'*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29'?|?
17. |?GRANT?ALL?PRIVILEGES?ON?`MyDB`.`kkk`?TO?'test'@'%'??????????????????????????????????????????????????|?
18. +-----------------------------------------------------------------------------------------------------+?
19. 2?rows?in?set?(0.00?sec)?
20. ??
21. mysql>?select?*?from?mysql.tables_priv\G;?
22. ***************************?1.?row?***************************?
23. ???????Host:?%?
24. ?????????Db:?MyDB?
25. ???????User:?test?
26. ?Table_name:?kkk?
27. ????Grantor:?root@localhost?
28. ??Timestamp:?0000-00-00?00:00:00?
29. ?Table_priv:?Select,Insert,Update,Delete,Create,Drop,References,Index,Alter,Create?View,Show?view,Trigger?
30. Column_priv:??
31. 1?row?in?set?(0.01?sec)?
32. ??
33. ERROR:??
34. No?query?specified?
35. ??
36. mysql>??

4：那么我们来创建一个测试账号test,授予列层级的权限.如下所示：

?

1. mysql>?drop?user?test;?
2. Query?OK,?0?rows?affected?(0.00?sec)?
3. ??
4. mysql>?grant?select?(id,?col1)?on?MyDB.TEST1?to?test@'%'?identified?by?'test';?
5. Query?OK,?0?rows?affected?(0.01?sec)?
6. ??
7. mysql>?flush?privileges;?
8. Query?OK,?0?rows?affected?(0.00?sec)?
9. ??
10. mysql>??
11. ??
12. ??
13. mysql>?select?*?from?mysql.columns_priv;?
14. +------+------+------+------------+-------------+---------------------+-------------+?
15. |?Host?|?Db???|?User?|?Table_name?|?Column_name?|?Timestamp???????????|?Column_priv?|?
16. +------+------+------+------------+-------------+---------------------+-------------+?
17. |?%????|?MyDB?|?test?|?TEST1??????|?id??????????|?0000-00-00?00:00:00?|?Select??????|?
18. |?%????|?MyDB?|?test?|?TEST1??????|?col1????????|?0000-00-00?00:00:00?|?Select??????|?
19. +------+------+------+------------+-------------+---------------------+-------------+?
20. 2?rows?in?set?(0.00?sec)?
21. ??
22. mysql>?show?grants?for?test;?
23. +-----------------------------------------------------------------------------------------------------+?
24. |?Grants?for?test@%???????????????????????????????????????????????????????????????????????????????????|?
25. +-----------------------------------------------------------------------------------------------------+?
26. |?GRANT?USAGE?ON?*.*?TO?'test'@'%'?IDENTIFIED?BY?PASSWORD?'*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29'?|?
27. |?GRANT?SELECT?(id,?col1)?ON?`MyDB`.`TEST1`?TO?'test'@'%'?????????????????????????????????????????????|?
28. +-----------------------------------------------------------------------------------------------------+?
29. 2?rows?in?set?(0.00?sec)?
30. ??
31. mysql>??

（编辑：ASP站长网）