table_privileges
Overview
View the authorization information of the table.
Database
information_schema
Table Information
Column Name | Type | Description |
---|---|---|
GRANTEE | varchar(81) | The authorized user |
TABLE_CATALOG | varchar(512) | The name of the Catalog |
TABLE_SCHEMA | varchar(64) | The name of the Database |
TABLE_NAME | varchar(64) | The name of the Table |
PRIVILEGE_TYPE | varchar(64) | The type of privilege |
IS_GRANTABLE | varchar(3) | Whether the privilege can be granted to others |