Re: Bug #703: granted permisions lost next day

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: petr(dot)husak(at)meiller(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #703: granted permisions lost next day
Date: 2002-07-03 15:06:35
Message-ID: 24884.1025708795@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> Hello, I've a table named map. I need to allow all users to select from this table. "GRANT select ON map TO public ;" works but permissions are lost next day and I must grant them again and again. I also tried to do it in a transaction: "BEGIN ; GRANT select ON map TO public ; COMMIT ;" but without any efect. Thanks for any help.

I'll bet lunch that you have some nightly batch client that's dropping
and recreating the table, or perhaps just REVOKEing permissions on it.
Permissions do not magically disappear.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2002-07-03 15:52:23 Re: Bug #703: granted permisions lost next day
Previous Message Tom Lane 2002-07-03 14:40:07 Re: Bug #702: NULLs order by bug in 7.2.1