全部产品
云市场

PRIVILEGE

更新时间:2019-09-18 13:14:12

  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 ...]