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,...)?
Дата
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 по дате отправления
От: Peter Eisentraut
Дата: