- Documentation Library
- Table of Contents
- MySQL 5.0 Manual
- Table of Contents
MySQL 5.0 Reference Manual :: 22 La base de données d'informations INFORMATION_SCHEMA :: 22.1 Les tables INFORMATION_SCHEMA :: 22.1.7 La table INFORMATION_SCHEMA TABLE_PRIVILEGES
Section Navigation [Toggle]
- 22.1 Les tables INFORMATION_SCHEMA
- 22.1.1 La table INFORMATION_SCHEMA SCHEMATA
- 22.1.2 La table INFORMATION_SCHEMA TABLES
- 22.1.3 La table INFORMATION_SCHEMA COLUMNS
- 22.1.4 La table INFORMATION_SCHEMA STATISTICS
- 22.1.5 La table INFORMATION_SCHEMA USER_PRIVILEGES
- 22.1.6 La table INFORMATION_SCHEMA SCHEMA_PRIVILEGES
- 22.1.7 La table INFORMATION_SCHEMA TABLE_PRIVILEGES
- 22.1.8 La table INFORMATION_SCHEMA COLUMN_PRIVILEGES
- 22.1.9 La table INFORMATION_SCHEMA CHARACTER_SETS
- 22.1.10 La table INFORMATION_SCHEMA COLLATIONS
- 22.1.11 La table INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY
- 22.1.12 La table INFORMATION_SCHEMA TABLE_CONSTRAINTS
- 22.1.13 La table INFORMATION_SCHEMA KEY_COLUMN_USAGE
- 22.1.14 La table INFORMATION_SCHEMA ROUTINES
- 22.1.15 La table INFORMATION_SCHEMA VIEWS
- 22.1.16 Autres tables INFORMATION_SCHEMA
La table TABLE_PRIVILEGES affiche les
informations sur les droits des tables. Ces informations
proviennent de mysql.tables_priv.
| Nom standard | Nom SHOW |
Remarques |
GRANTOR |
omis | |
GRANTEE |
i.e. 'utilisateur'@'hote' | |
TABLE_CATALOG |
NULL |
|
TABLE_SCHEMA |
||
TABLE_NAME |
||
PRIVILEGE_TYPE |
||
IS_GRANTABLE |
||
WITH_HIERARCHY |
omit |
Les requêtes suivantes ne sont pas équivalentes :
SELECT ... FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES SHOW GRANTS ...
PRIVILEGE_TYPE peut contenir l'une des
valeurs suivantes : SELECT,
INSERT, UPDATE,
REFERENCES, ALTER,
INDEX, DROP et
CREATE VIEW.
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.
