Postgres Pro
Downloads
Home   >   mailing lists

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

From S. Bob
Subject Make grant all on all tables in schema x persistent for new tables
Date
Msg-id b2787e7e-9a2c-1613-fa1f-0bd279280977@quadratum-braccas.com
Whole thread Raw
Responses Re: Make grant all on all tables in schema x persistent for new tables  (Steven Crandell <steven.crandell@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: Unique cluster / instance identifier?
Next
From: Steven Crandell
Date:
Subject: Re: Make grant all on all tables in schema x persistent for new tables