- 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.6 La table INFORMATION_SCHEMA SCHEMA_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 SCHEMA_PRIVILEGES fournit des
informations sur les droits des schémas (l'autre nom des bases
de données). Ces informations proviennent de la table
mysql.db.
| Nom standard | Nom SHOW |
Remarques |
GRANTEE |
i.e.g. 'utilisateur'@'hote' | |
TABLE_CATALOG |
NULL |
|
TABLE_SCHEMA |
||
PRIVILEGE_TYPE |
||
IS_GRANTABLE |
Notes :
Ceci est une table non-standard. Elle prend ses valeurs dans la table
mysql.db.
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.
