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