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

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

you can use the 'alter default privileges' command and grant whatever
permission you want to a user by default when a new table is created -> 
https://www.postgresql.org/docs/9.4/sql-alterdefaultprivileges.html



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html