On Wed, Nov 14, 2018 at 10:05:51AM -0600, Ron wrote: > On 11/14/2018 08:19 AM, Nicolas Paris wrote: > > Hi > > > > I d'like my user be able to select on any new table from other users. > > > Would ROLE Groups solve your problem? Maybe yes, not sure what it is. I tested this: > create role myrolegroup; > ALTER DEFAULT PRIVILEGES FOR ROLE "myrolegroup" IN SCHEMA "myschema" GRANT select ON TABLES TO "myuser"; > create myuser1 inherit in role myrolegroup; > create myuser2 inherit in role myrolegroup; But if myuser2 creates a table, then myuser1 cannot select on it. I guess that's because inheritance only apply for GRANT (which is distinct from DEFAUL PRIVILEGE). Thanks, -- nicolas
