In RDS postgres, I have a user/role named master_user with rds_superuser permission.
I created a new db user
user1using the master username/password.I created a db table named
test_tableusing the new useruser1.I created a new db user
user2using the master username/password;I tried to grant all privileges on all tables for
user2while using master username/password. However, I got errors like this:
postgres=> GRANT ALL ON ALL TABLES IN SCHEMA public TO user2;
ERROR: permission denied for relation test_table
Why I still got permission denied error while using the master username&password? What's the workaround here?