RE: [postgis-users] auto GRANT on new table

2008-02-28 Thread Obe, Regina
r answer do not suffice, you might have better luck asking this question on http://archives.postgresql.org/pgsql-general/ since it really has nothing to do with PostGIS. Hope that helps, Regina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac

Re: [postgis-users] auto GRANT on new table

2008-02-28 Thread Maciej Sieczka
Mark Cave-Ayland pisze: On Friday 22 February 2008 06:58:59 Maciej Sieczka wrote: Hi Mark! My first post here. Hi All! Sorry if the issue was already discussed. I have searched the net and your archives for several hours not finding an answer. There are 2 role groups in my cluster: "editors

Re: [postgis-users] auto GRANT on new table

2008-02-27 Thread Kevin Neufeld
Hi Maciek, As far as I know, you can't add triggers to system tables. Consequently, I don't know of anyway to automatically GRANT rights to a newly created table, except for a nightly run cron job you could set up. To answer your second question, yes, you can prevent other "editors" from mo

Re: [postgis-users] auto GRANT on new table

2008-02-22 Thread Mark Cave-Ayland
On Friday 22 February 2008 06:58:59 Maciej Sieczka wrote: Hi Maciej, > My first post here. Hi All! > > Sorry if the issue was already discussed. I have searched the net and > your archives for several hours not finding an answer. > > There are 2 role groups in my cluster: "editors" and "viewers".

[postgis-users] auto GRANT on new table

2008-02-21 Thread Maciej Sieczka
Hello, My first post here. Hi All! Sorry if the issue was already discussed. I have searched the net and your archives for several hours not finding an answer. There are 2 role groups in my cluster: "editors" and "viewers". In each group there are several users. In the DB, "editors" are allowe