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

5：那么我们来创建一个测试账号test,授子程序层级的权限.如下所示：

?

1. mysql>?DROP?PROCEDURE?IF?EXISTS?PRC_TEST;?
2. Query?OK,?0?rows?affected?(0.00?sec)?
3. ??
4. mysql>?DELIMITER?//?
5. mysql>?CREATE?PROCEDURE?PRC_TEST()?
6. ????->?BEGIN?
7. ????->????SELECT?*?FROM?kkk;?
8. ????->?END?//?
9. Query?OK,?0?rows?affected?(0.00?sec)?
10. ??
11. mysql>?DELIMITER?;?
12. ??
13. mysql>?grant?execute?on?procedure?MyDB.PRC_TEST?to?test@'%'?identified?by?'test';?
14. Query?OK,?0?rows?affected?(0.00?sec)?
15. ??
16. mysql>??
17. ??
18. ??
19. mysql>?show?grants?for?test;?
20. +-----------------------------------------------------------------------------------------------------+?
21. |?Grants?for?test@%???????????????????????????????????????????????????????????????????????????????????|?
22. +-----------------------------------------------------------------------------------------------------+?
23. |?GRANT?USAGE?ON?*.*?TO?'test'@'%'?IDENTIFIED?BY?PASSWORD?'*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29'?|?
24. |?GRANT?EXECUTE?ON?PROCEDURE?`MyDB`.`prc_test`?TO?'test'@'%'??????????????????????????????????????????|?
25. +-----------------------------------------------------------------------------------------------------+?
26. 2?rows?in?set?(0.00?sec)?
27. ??
28. mysql>?select?*?from?mysql.procs_priv?where?User='test';?
29. +------+------+------+--------------+--------------+----------------+-----------+---------------------+?
30. |?Host?|?Db???|?User?|?Routine_name?|?Routine_type?|?Grantor????????|?Proc_priv?|?Timestamp???????????|?
31. +------+------+------+--------------+--------------+----------------+-----------+---------------------+?
32. |?%????|?MyDB?|?test?|?PRC_TEST?????|?PROCEDURE????|?root@localhost?|?Execute???|?0000-00-00?00:00:00?|?
33. +------+------+------+--------------+--------------+----------------+-----------+---------------------+?
34. 1?row?in?set?(0.00?sec)?
35. ??
36. mysql>??

所以,如果需要查看用户被授予的权限,就需要从这五个层级来查看被授予的权限.从上到下或从小到上,逐一检查各个层级被授予的权限.

（编辑：ASP站长网）