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

Bug #703: granted permisions lost next day

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




Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-07-03 14:40:07
Subject: Re: Bug #702: NULLs order by bug in 7.2.1
Previous:From: Stephan SzaboDate: 2002-07-03 06:11:17
Subject: Re: Bug #702: NULLs order by bug in 7.2.1

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