information_schema.applicable_roles.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
applicable_roles |
||||||||
grantee |
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
grantee_host |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
grantee_type |
unsupported | unsupported | unsupported | unsupported | unsupported | unsupported | ||
host |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
is_default |
VARCHAR NULL:
8
| NULL:
| unsupported | unsupported | unsupported | unsupported | ||
is_grantable |
VARCHAR NOT NULL:
8
| VARCHAR NOT NULL:
NULL:
| unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | |||
is_mandatory |
VARCHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
role_host |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
role_name |
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | |||
user |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||