Using postgres permissions from docs does not work on RDS #1677
Description
via fusillicode#3122 on Discord.
Following the instructions here does not work on RDS.
Results in error:
sql> GRANT SELECT ON ALL TABLES IN SCHEMA information_schema TO hasurauser
[2019-02-28 13:03:13] [42501] ERROR: permission denied for relation sql_parts
sql> GRANT SELECT ON ALL TABLES IN SCHEMA pg_catalog TO hasurauser
[2019-02-28 13:03:17] [42501] ERROR: permission denied for relation pg_statistic
Probably because RDS restricts specific tables in pg_catalog and information_schema.