Re: 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 far.  You could also write a
stored procedure.

> 2.(Not sure if this works) Insert a trigger on postgres's internal
> tables in template1 that grants permission to a group say
> <dbname>_group to the created object. Developers that need access to
> the database can then be added to that group.

Triggers on system tables don't work.