From: Ulrich Meis <kenobi@halifax.rwth-aachen.de>
To: pgsql-admin@postgresql.org
Subject: How do I grant access to entire database at once(schemas,tables,sequences,...)?
Date: Mon, 17 May 2004 18:53:58 +0200
Message-ID: <40A8EE26.70405@halifax.rwth-aachen.de> (raw)
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 be 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
<dbname>_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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: kenobi@halifax.rwth-aachen.de
Subject: Re: How do I grant access to entire database at once(schemas,tables,sequences,...)?
In-Reply-To: <40A8EE26.70405@halifax.rwth-aachen.de>
References: <40A8EE26.70405@halifax.rwth-aachen.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox