PostgreSQL Administration Cookbook, 9.5/9.6 Edition

How to do it...

Grant access to the schema containing the table, as follows:

GRANT USAGE ON someschema TO somerole; GRANT SELECT, INSERT, UPDATE, DELETE ON someschema.sometable TO somerole; GRANT somerole TO someuser, otheruser;