futureじゃないgrantsでは、schemaはgrants on schemaで、roleはgrants to role
SHOW GRANTS [ LIMIT <rows> ] SHOW GRANTS ON ACCOUNT [ LIMIT <rows> ] SHOW GRANTS ON <object_type> <object_name> [ LIMIT <rows> ] SHOW GRANTS TO { APPLICATION <app_name> | APPLICATION ROLE [ <app_name>. ]<app_role_name> | ROLE <role_name> | SHARE <share_name> [ IN APPLICATION PACKAGE <app_package_name> ] | USER <user_name> } [ LIMIT <rows> ] SHOW GRANTS OF { APPLICATION ROLE <app_role_name>| ROLE <role_name> } [ LIMIT <rows> ] SHOW GRANTS OF SHARE <share_name> [ LIMIT <rows> ] SHOW FUTURE GRANTS IN SCHEMA { <schema_name> } [ LIMIT <rows> ] SHOW FUTURE GRANTS IN DATABASE { <database_name> } [ LIMIT <rows> ] SHOW FUTURE GRANTS TO ROLE <role_name> [ LIMIT <rows> ]
