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

另请参阅