语句如下:

    1. grant_stmt:
    2. GRANT privilege_type_list ON privilege_level TO user_option_list [WITH GRANT OPTION];
    3. revoke_stmt:
    4. REVOKE privilege_type_list ON privilege_level FROM user_name_list;
    5. show_grants_stmt:
    6. SHOW GRANTS [FOR user_name];
    7. privilege_type_list:
    8. {ALL [PRIVILEGES] | privilege_type [, privilege_type ...]}
    9. privilege_type:
    10. ALTER
    11. | CREATE
    12. | CREATE USER
    13. | CREATE VIEW
    14. | DELETE
    15. | DROP
    16. | GRANT OPTION
    17. | INDEX
    18. | INSERT
    19. | PROCESS
    20. | SELECT
    21. | SHOW DATABASES
    22. | SHOW VIEW
    23. | SUPER
    24. | UPDATE
    25. | USAGE
    26. privilege_level:
    27. *
    28. | *.*
    29. | database_name.*
    30. | database_name.table_name
    31. | table_name
    32. user_option_list:
    33. user_option [, user_option ...]
    34. user_option:
    35. user_name [IDENTIFIED BY 'password']
    36. password:
    37. STR_VALUE
    38. user_name_list:
    39. user_name [, user_name ...]