Bug #703: granted permisions lost next day

pgsql-bugs@postgresql.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

Very strange. I can't imagine what would cause this.

---------------------------------------------------------------------------

pgsql-bugs@postgresql.org wrote:

Petr Husak (petr.husak@meiller.com) reports a bug with a severity
of 2 The lower the number the more severe it is.

Short Description granted permisions lost next day

Long Description 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.

Sample Code

No file was uploaded with this report

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an
appropriate subscribe-nomail command to majordomo@postgresql.org
so that your message can get through to the mailing list cleanly

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026