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 |