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

Поиск
Список
Период
Сортировка
Искать
От
Ulrich Meis
Тема
How do I grant access to entire database at once(schemas,tables,sequences,...)?
Дата
в 15:53:29
Msg-id
40A8D55A.9040600@halifax.rwth-aachen.de
Список
Дерево обсуждения
How do I grant access to entire database at once(schemas,tables,sequences,...)? Ulrich Meis <kenobi@halifax.rwth-aachen.de>
Re: How do I grant access to entire database at once(schemas,tables,sequences,...)? Peter Eisentraut <peter_e@gmx.net>
Re: How do I grant access to entire database at Randall Perry <rgp@systame.com>
Re: How do I grant access to entire database at Oliver Elphick <olly@lfix.co.uk>
Re: How do I grant access to entire database at Randall Perry <rgp@systame.com>
Re: How do I grant access to entire database at Jean-Luc Lachance <jllachan@sympatico.ca>
Re: How do I grant access to entire database at Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
Re: How do I grant access to entire database at Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
Re: How do I grant access to entire database at Tom Lane <tgl@sss.pgh.pa.us>
Re: How do I grant access to entire database at Randall Perry <rgp@systame.com>
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 
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.

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

Both solutions require a serious amount of work compared to the simple task.
Is there a simpler or better way to do this?

Thanks for any ideas and comments!

greetings,

Uli


В списке pgsql-admin по дате отправления
От: Saket Bagade
Дата:
От: Peter Eisentraut
Дата:
FAQ