SHOW PRIVILEGES

SHOW PRIVILEGES 语句用于显示 TiDB 中可分配权限的列表。此列表为静态列表，不反映当前用户的权限。

语法图

ShowStmt:

ShowStmt

示例

  1. mysql> show privileges;
  2. +-------------------------+---------------------------------------+-------------------------------------------------------+
  3. | Privilege               | Context                               | Comment                                               |
  4. +-------------------------+---------------------------------------+-------------------------------------------------------+
  5. | Alter                   | Tables                                | To alter the table                                    |
  6. | Alter                   | Tables                                | To alter the table                                    |
  7. | Alter routine           | Functions,Procedures                  | To alter or drop stored functions/procedures          |
  8. | Create                  | Databases,Tables,Indexes              | To create new databases and tables                    |
  9. | Create routine          | Databases                             | To use CREATE FUNCTION/PROCEDURE                      |
  10. | Create temporary tables | Databases                             | To use CREATE TEMPORARY TABLE                         |
  11. | Create view             | Tables                                | To create new views                                   |
  12. | Create user             | Server Admin                          | To create new users                                   |
  13. | Delete                  | Tables                                | To delete existing rows                               |
  14. | Drop                    | Databases,Tables                      | To drop databases, tables, and views                  |
  15. | Event                   | Server Admin                          | To create, alter, drop and execute events             |
  16. | Execute                 | Functions,Procedures                  | To execute stored routines                            |
  17. | File                    | File access on server                 | To read and write files on the server                 |
  18. | Grant option            | Databases,Tables,Functions,Procedures | To give to other users those privileges you possess   |
  19. | Index                   | Tables                                | To create or drop indexes                             |
  20. | Insert                  | Tables                                | To insert data into tables                            |
  21. | Lock tables             | Databases                             | To use LOCK TABLES (together with SELECT privilege)   |
  22. | Process                 | Server Admin                          | To view the plain text of currently executing queries |
  23. | Proxy                   | Server Admin                          | To make proxy user possible                           |
  24. | References              | Databases,Tables                      | To have references on tables                          |
  25. | Reload                  | Server Admin                          | To reload or refresh tables, logs and privileges      |
  26. | Replication client      | Server Admin                          | To ask where the slave or master servers are          |
  27. | Replication slave       | Server Admin                          | To read binary log events from the master             |
  28. | Select                  | Tables                                | To retrieve rows from table                           |
  29. | Show databases          | Server Admin                          | To see all databases with SHOW DATABASES              |
  30. | Show view               | Tables                                | To see views with SHOW CREATE VIEW                    |
  31. | Shutdown                | Server Admin                          | To shut down the server                               |
  32. | Super                   | Server Admin                          | To use KILL thread, SET GLOBAL, CHANGE MASTER, etc.   |
  33. | Trigger                 | Tables                                | To use triggers                                       |
  34. | Create tablespace       | Server Admin                          | To create/alter/drop tablespaces                      |
  35. | Update                  | Tables                                | To update existing rows                               |
  36. | Usage                   | Server Admin                          | No privileges - allow connect only                    |
  37. +-------------------------+---------------------------------------+-------------------------------------------------------+
  38. 32 rows in set (0.00 sec)

MySQL 兼容性

SHOW PRIVILEGES 语句与 MySQL 完全兼容。如有任何兼容性差异，请在 GitHub 上提交 issue。

另请参阅