information_schema
.role_table_grants
.*
relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
---|---|---|---|---|---|---|---|---|
role_table_grants |
||||||||
grantee |
CHAR NOT NULL :
8
| unsupported | unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| unsupported | |||
grantee_host |
CHAR NOT NULL :
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
grantor |
VARCHAR NULL :
8
| unsupported | unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| unsupported | |||
grantor_host |
VARCHAR NULL :
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
is_grantable |
VARCHAR NOT NULL :
8
| unsupported | unsupported | CHARACTER_DATA :
YES_OR_NO NULL :
| unsupported | |||
privilege_type |
SET NOT NULL :
8
| unsupported | unsupported | CHARACTER_DATA :
CHARACTER_DATA NULL :
| unsupported | |||
table_catalog |
VARCHAR NOT NULL :
8
| unsupported | unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| unsupported | |||
table_name |
CHAR NOT NULL :
8
| unsupported | unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| unsupported | |||
table_schema |
CHAR NOT NULL :
8
| unsupported | unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| unsupported | |||
with_hierarchy |
unsupported | unsupported | unsupported | CHARACTER_DATA :
YES_OR_NO :
YES_OR_NO NULL :
| unsupported |