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.