information_schema.TABLE_PRIVILEGES

2025-12-09 07:09:36  Updated

Feature

This view displays the information about table privileges.

Fields

Field Type Nullable Description
GRANTEE varchar(81) NO The username of the user to which the privilege is granted.
TABLE_CATALOG varchar(4096) NO The name of the catalog to which the table belongs.
TABLE_SCHEMA varchar(128) NO The name of the database.
TABLE_NAME varchar(64) NO The name of the table.
PRIVILEGE_TYPE varchar(64) NO The type of the privilege.
IS_GRANTABLE varchar(3) NO Indicates whether the user has the GRANT OPTION privilege.

Contact Us