CREATE ROLE foo WITH LOGIN; CREATE ROLE bar WITH LOGIN IN ROLE foo; CREATE ROLE baz WITH LOGIN; \c - foo ALTER DEFAULT PRIVILEGES GRANT SELECT ON TABLES TO bar; \c - bar CREATE TABLE tab_one(); \ddp