这是indexloc提供的服务,不要输入任何密码
Skip to content

Using postgres permissions from docs does not work on RDS #1677

@ecthiender

Description

@ecthiender

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.

Metadata

Metadata

Labels

c/docsRelated to docse/easycan be wrapped up in a couple of daysp/mediumnon-urgent issues/features that are candidates for being included in one of the upcoming sprints

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions