information_schema.user_privileges.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
user_privileges |
||||||||
grantee |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(81) NULL:
| unsupported | unsupported | |||
is_grantable |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(3) NULL:
| unsupported | unsupported | |||
privelege_type |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
privilege_type |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | |||
table_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NULL:
| unsupported | unsupported | |||