information_schema
.role_column_grants
.*
relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
---|---|---|---|---|---|---|---|---|
role_column_grants |
||||||||
column_name |
CHAR NOT NULL :
8
| unsupported | unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| unsupported | unsupported | ||
grantee |
CHAR NOT NULL :
8
| unsupported | unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| unsupported | unsupported | ||
grantee_host |
CHAR NOT NULL :
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
grantor |
VARCHAR NULL :
8
| unsupported | unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| unsupported | 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 | unsupported | ||
privilege_type |
SET NOT NULL :
8
| unsupported | unsupported | CHARACTER_DATA :
CHARACTER_DATA NULL :
| unsupported | unsupported | ||
table_catalog |
VARCHAR NOT NULL :
8
| unsupported | unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| unsupported | unsupported | ||
table_name |
CHAR NOT NULL :
8
| unsupported | unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| unsupported | unsupported | ||
table_schema |
CHAR NOT NULL :
8
| unsupported | unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| unsupported | unsupported |