information_schema.table_privileges.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
table_privileges |
||||||||
grantee |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
grantee_type |
unsupported | unsupported | unsupported | unsupported | unsupported | unsupported | ||
grantor |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
grantor_type |
unsupported | unsupported | unsupported | unsupported | unsupported | unsupported | ||
is_grantable |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| VARCHAR(3) NULL:
| |||
privilege_type |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| VARCHAR(10) NULL:
| |||
table_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| SYSNAME NULL:
| |||
table_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
with_hierarchy |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO:
YES_OR_NO NULL:
| unsupported | |||