I am moving to a group role from a lot of individual users and have one table that needs to have permissions
Lets say I have:
user1 user2 newgroup
Both of the users are in the group and both users have INHERIT as well as the Group has INHERIT on it.
I have added
GRANT USAGE ON SCHEMA testschema TO newgroup; GRANT user1 to newgroup; GRANT user2 to newgroup;
as well as
GRANT SELECT, INSERT ON testschema.testtable TO newgroup;
When I log in as one of the new users, I do not have permission to that table(ex: testschema.testtable)
I look at the PSQL \z and see for that table newgroup has ar permissions.
I am getting permission denied for relation testschema.testtable. I do not want to create more of a mess by individually putting permissions on the table (it works if I do that currently).