> 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
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2002-07-03 15:52:23|
|Subject: Re: Bug #703: granted permisions lost next day|
|Previous:||From: Tom Lane||Date: 2002-07-03 14:40:07|
|Subject: Re: Bug #702: NULLs order by bug in 7.2.1 |