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 (
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.