I am trying to assign select privs via a role for current and future tables, and i cant see to figure this out. Please advise.
create role dev_role;
grant usage on schema address to dev_role
grant select on all tables in schema address to dev_role
alter default privileges in schema address grant select on tables to dev_role;
grant dev_role to test1;
Now, Test2 user creates a table in address schema that has grant all privileges.
\c dev test2
create table address.t1(t integer);
\c dev test1
select * from address_match.t1;
ERROR: permission denied for table t1