GRANT ALL ON ALL TABLES IN SCHEMA public TO orleansbookgrp; GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO orleansbookgrp; -- don't forget those ...