- Documentation Library
- Table of Contents
- MySQL 5.5 Manual
- MySQL 5.4 Manual
- MySQL 5.1 Manual
- MySQL 5.0 Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
MySQL 3.23, 4.0, 4.1 Reference Manual :: 12 SQL Statement Syntax :: 12.4 Database Administration Statements :: 12.4.5 SHOW Syntax :: 12.4.5.18 SHOW PRIVILEGES Syntax
Section Navigation [Toggle]
- 12.4.5 SHOW Syntax
- 12.4.5.1 SHOW BINARY LOGS Syntax
- 12.4.5.2 SHOW BINLOG EVENTS Syntax
- 12.4.5.3 SHOW CHARACTER SET Syntax
- 12.4.5.4 SHOW COLLATION Syntax
- 12.4.5.5 SHOW COLUMNS Syntax
- 12.4.5.6 SHOW CREATE DATABASE Syntax
- 12.4.5.7 SHOW CREATE TABLE Syntax
- 12.4.5.8 SHOW DATABASES Syntax
- 12.4.5.9 SHOW ENGINE Syntax
- 12.4.5.10 SHOW ENGINES Syntax
- 12.4.5.11 SHOW ERRORS Syntax
- 12.4.5.12 SHOW GRANTS Syntax
- 12.4.5.13 SHOW INDEX Syntax
- 12.4.5.14 SHOW INNODB STATUS Syntax
- 12.4.5.15 SHOW LOGS Syntax
- 12.4.5.16 SHOW MASTER STATUS Syntax
- 12.4.5.17 SHOW OPEN TABLES Syntax
- 12.4.5.18 SHOW PRIVILEGES Syntax
- 12.4.5.19 SHOW PROCESSLIST Syntax
- 12.4.5.20 SHOW SLAVE HOSTS Syntax
- 12.4.5.21 SHOW SLAVE STATUS Syntax
- 12.4.5.22 SHOW STATUS Syntax
- 12.4.5.23 SHOW TABLE STATUS Syntax
- 12.4.5.24 SHOW TABLES Syntax
- 12.4.5.25 SHOW VARIABLES Syntax
- 12.4.5.26 SHOW WARNINGS Syntax
SHOW PRIVILEGES
SHOW PRIVILEGES shows the list of
system privileges that the MySQL server supports. This statement
is implemented as of MySQL 4.1.0. The exact list of privileges
depends on the version of your server.
mysql> SHOW PRIVILEGES\G
*************************** 1. row ***************************
Privilege: Alter
Context: Tables
Comment: To alter the table
*************************** 2. row ***************************
Privilege: Create temporary tables
Context: Databases
Comment: To use CREATE TEMPORARY TABLE
*************************** 3. row ***************************
Privilege: Create
Context: Databases,Tables,Indexes
Comment: To create new databases and tables
*************************** 4. row ***************************
Privilege: Delete
Context: Tables
Comment: To delete existing rows
*************************** 5. row ***************************
Privilege: Drop
Context: Databases,Tables
Comment: To drop databases and tables
...
Privileges belonging to a specific user are displayed by the
SHOW GRANTS statement. See
Section 12.4.5.12, “SHOW GRANTS Syntax”, for more information.
User Comments
Add your own comment.