Обсуждение: Bug #703: granted permisions lost next day

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 ;"
worksbut 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

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 ;"
worksbut 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