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

Re: BUG #1150: grant options not properly checked

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Cc: pgsql-bugs(at)postgresql(dot)org, Peter Eisentraut <peter_e(at)gmx(dot)net>
Subject: Re: BUG #1150: grant options not properly checked
Date: 2004-05-11 15:57:46
Message-ID: 10704.1084291066@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> writes:
> While browsing the Access Rules of <revoke statement>... it is unclear.

I generally find SQL92 easier to read than SQL99.  In SQL92,
section 11.37 <revoke statement> says

         8) For every combination of <grantee> and <action> on O specified
            in <privileges>, if there is no corresponding privilege de-
            scriptor in the set of identified privilege descriptors, then a
            completion condition is raised: warning-privilege not revoked.

         9) If ALL PRIVILEGES was specified, then for each <grantee>, if
            no privilege descriptors were identified, then a completion
            condition is raised: warning-privilege not revoked.

which seems parallel to the GRANT case: warning, but no error.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Fabien COELHODate: 2004-05-11 16:20:34
Subject: Re: BUG #1150: grant options not properly checked
Previous:From: Fabien COELHODate: 2004-05-11 15:51:10
Subject: Re: BUG #1150: grant options not properly checked

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