Re: How do I grant access to entire database at
От
Randall Perry
Тема
Re: How do I grant access to entire database at
Дата
Msg-id
BD204D49.7DA1B%rgp@systame.com
Ответ на
Re: How do I grant access to entire database at once(schemas,tables,sequences,...)? (Peter Eisentraut)
Список
Дерево обсуждения
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>
This is a pain. Couldn't we gave something simple like GRANT ALL ON database.* TO JOE; Which would grant full access to all objects in the database to JOE for all time? > 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. > -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Design/Development WebObjects Hosting Mac Consulting/Sales http://www.systame.com/
В списке pgsql-admin по дате отправления
От: Dario V. Fassi
Дата:
