Skip site navigation (1) Skip section navigation (2)

Re: Bug #703: granted permisions lost next day

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 (view raw or flat)
Thread:
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



In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2002-07-03 15:52:23
Subject: Re: Bug #703: granted permisions lost next day
Previous:From: Tom LaneDate: 2002-07-03 14:40:07
Subject: Re: Bug #702: NULLs order by bug in 7.2.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group