Re: Bug #703: granted permisions lost next day

Lists: pgsql-bugs
From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #703: granted permisions lost next day
Date: 2002-07-03 06:38:48
Message-ID: 20020703063848.925CF4761CE@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

Petr Husak (petr(dot)husak(at)meiller(dot)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


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
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


From: Bruce Momjian <pgman(at)candle(dot)pha(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:52:23
Message-ID: 200207031552.g63FqNb11728@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs


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

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

pgsql-bugs(at)postgresql(dot)org wrote:
> Petr Husak (petr(dot)husak(at)meiller(dot)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(at)postgresql(dot)org
> so that your message can get through to the mailing list cleanly
>
>
>

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