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 |