[ADMIN] How do I grant access to entire database at once(schemas,tables,sequences,...)?

Hi ! I administrate a development server for a little team, and people want to be able to grant access to an entire database to other developers/freelancers. Up till now, I see two possibilities : 1. Write a script that queries the postgres internal tables for all

[ADMIN] How do I grant access to entire database at once(schemas,tables,sequences,...)?

Hi ! I administrate a development server for a little team, and people want to be able to grant access to an entire database to other developers/freelancers. Up till now, I see two possibilities : 1. Write a script that queries the postgres internal tables for all

Re: [ADMIN] How do I grant access to entire database at once(schemas,tables,sequences,...)?

Ulrich Meis wrote: 1. Write a script that queries the postgres internal tables for all tables,schemas,sequences,views,functions,... and then executes grant statements for each one of them. This would have to repeated each time a new object is created. Yes, that's the most popular method so