SHOW PRIVILEGES

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

语法图

ShowStmt:

ShowStmt

示例

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

MySQL 兼容性

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

另请参阅