[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
