information_schema.role_routine_grants.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
role_routine_grants |
||||||||
grantee |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
grantee_host |
CHAR NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
grantor |
VARCHAR NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
grantor_host |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
is_grantable |
VARCHAR NOT NULL:
8
| unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | unsupported | ||
privilege_type |
SET NOT NULL:
8
| unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
routine_catalog |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_name |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
routine_schema |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_catalog |
VARCHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_name |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
specific_schema |
CHAR NOT NULL:
8
| unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||