13.7.5.26 SHOW PRIVILEGES 声明
SHOW PRIVILEGES
SHOW PRIVILEGES显示 MySQL 服务器支持的系统特权列 table。特权的确切列 table 取决于服务器的版本。
mysql> SHOW PRIVILEGES\G
*************************** 1. row ***************************
Privilege: Alter
Context: Tables
Comment: To alter the table
*************************** 2. row ***************************
Privilege: Alter routine
Context: Functions,Procedures
Comment: To alter or drop stored functions/procedures
*************************** 3. row ***************************
Privilege: Create
Context: Databases,Tables,Indexes
Comment: To create new databases and tables
*************************** 4. row ***************************
Privilege: Create routine
Context: Databases
Comment: To use CREATE FUNCTION/PROCEDURE
*************************** 5. row ***************************
Privilege: Create temporary tables
Context: Databases
Comment: To use CREATE TEMPORARY TABLE
...
SHOW GRANTS语句显示属于特定用户的特权。有关更多信息,请参见第 13.7.5.21 节“ SHOW GRANTS 语句”。