28.3.43 INFORMATION_SCHEMA TABLE_PRIVILEGES 表
The TABLE_PRIVILEGES
table provides information about table privileges. It takes its values from the mysql.tables_priv
system table.
The TABLE_PRIVILEGES
table has these columns:
-
GRANTEE
The name of the account to which the privilege is granted, in
'
format.user_name
'@'host_name
' -
TABLE_CATALOG
The name of the catalog to which the table belongs. This value is always
def
. -
TABLE_SCHEMA
The name of the schema (database) to which the table belongs.
-
TABLE_NAME
The name of the table.
-
PRIVILEGE_TYPE
The privilege granted. The value can be any privilege that can be granted at the table level; see Section 15.7.1.6, “GRANT Statement”. Each row lists a single privilege, so there is one row per table privilege held by the grantee.
-
IS_GRANTABLE
YES
if the user has theGRANT OPTION
privilege,NO
otherwise. The output does not listGRANT OPTION
as a separate row withPRIVILEGE_TYPE='GRANT OPTION'
.
-
TABLE_PRIVILEGES
is a nonstandardINFORMATION_SCHEMA
table.
The following statements are not equivalent:
SELECT ... FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES
SHOW GRANTS ...