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

[Steven Crandell <steven.crandell@xxxxxxxxx>]

On Mon, Feb 18, 2019 at 12:09 PM S. Bob <sbob@xxxxxxxxxxxxxxxxxxxxx> wrote:

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

Take a look at default privileges here: 

https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html