ユーザーにselect権限を与えてあげばいい。
該当ユーザーを探し出し、
select usename from pg_user;
select権限を与える。
grant select on テーブル名 to ユーザー名;
More than 3 years have passed since last update.
Error running query: permission denied for relation テーブル名
Last updated at Posted at 2021-06-18
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme