Re: BUG #1145: silent REVOKE failures - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1145: silent REVOKE failures
Date
Msg-id 8648.1084921159@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #1145: silent REVOKE failures  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
Fabien COELHO <coelho@cri.ensmp.fr> writes:
> For the TODO, I would suggest something general:
> - fix grant/revoke wrt SQL standard, validate errors, warnings and successes.

I have a patch-in-progress that addresses these issues.  I didn't get it
quite finished before leaving for vacation, but hope to clean it up and
commit soon.  There was an open issue, which was whether we want the
owner's grant options to be shown in the default ACL value or not.
(This would be only cosmetic and not functional, because the code will
treat the owner as having grant options in any case.)  A related
question is whether the information_schema display of grant options
should track what the ACL says or tell the truth, namely that the owner
has grant options regardless.  (Doing the latter would force changing
the API of aclcontains(), hence initdb.)

I asked for opinions on this but got little feedback.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1142: Problem with update permissions for view
Next
From: Tom Lane
Date:
Subject: Re: Patch for not going beyond NOFILE system limit