I am using AWS RDS PostgreSQL and currently up and running. I would like to know how I can add a new user but only grant SELECT
on an existing DB.
The way I connect to my RDS from my PC is by using a app called pgAdmin III (from Ubuntu).
I tried to create a group called rds_guest
, assign a user (called webkul
) and finally GRANT
privileges (INSERT
, SELECT
, UPDATE
etc) on the database I want for that particular group:
When I try to login using that user and try perform actions on the desired database I get an error saying:
Permission denied for relation xxx_yyy
Can anyone help me with this ? I am relatively new with Postgres.