Postgres Pro
Downloads
Home   >   mailing lists

Re: Make grant all on all tables in schema x persistent for new tables - Mailing list pgsql-admin

From Steven Crandell
Subject Re: Make grant all on all tables in schema x persistent for new tables
Date
Msg-id CALvesgkUiHm3wQhRwQBxnJ-x13e2XDGTtpBKZjyXgpvGWuFpFA@mail.gmail.com
Whole thread Raw
In response to Make grant all on all tables in schema x persistent for new tables  ("S. Bob" <sbob@quadratum-braccas.com>)
Responses Re: Make grant all on all tables in schema x persistent for newtables  (MirrorX <mirrorx@gmail.com>)
List pgsql-admin
Tree view
On Mon, Feb 18, 2019 at 12:09 PM S. Bob <sbob@quadratum-braccas.com> 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: 

pgsql-admin by date:

Previous
From: "S. Bob"
Date:
Subject: Make grant all on all tables in schema x persistent for new tables
Next
From: soumitra bhandary
Date:
Subject: Load balancing in postgres master slave HA cluster