Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
The TABLE_PRIVILEGES table provides information about table privileges. This
information comes from the mysql.tables_priv grant table.
INFORMATION_SCHEMA Name |
SHOW Name
|
Remarks |
|---|---|---|
GRANTEE |
'value
|
|
TABLE_CATALOG |
def |
|
TABLE_SCHEMA |
||
TABLE_NAME |
||
PRIVILEGE_TYPE |
||
IS_GRANTABLE |
Notes:
PRIVILEGE_TYPE can contain one (and only one) of these
values: SELECT, INSERT, UPDATE, REFERENCES,
ALTER, INDEX, DROP, CREATE VIEW.
The following statements are not equivalent:
SELECT ... FROM INFORMATION_SCHEMA.TABLE_PRIVILEGESSHOW GRANTS ...