Make grant all on all tables in schema x persistent for new tables

From: "S(dot) Bob" <sbob(at)quadratum-braccas(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Make grant all on all tables in schema x persistent for new tables
Date: 2019-02-18 19:09:15
Message-ID: b2787e7e-9a2c-1613-fa1f-0bd279280977@quadratum-braccas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

All;

I can run a GRANT ALL ON ALL TABLES in SCHEMA X to USER Y

which of course grants all privileges to the user Y on all tables in
schema X

How do I make this the default permission for all future tables created
in schema X as well?

Thanks in advance

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steven Crandell 2019-02-18 19:11:21 Re: Make grant all on all tables in schema x persistent for new tables
Previous Message Andrew Gierth 2019-02-18 18:51:15 Re: Unique cluster / instance identifier?