Re: DROP PRIVILEGES OWNED BY

On 12/17/14 5:37 PM, Heikki Linnakangas wrote:
> On 12/15/2014 02:43 AM, Marko Tiikkaja wrote:
>> The syntax is:
>>
>>      DROP PRIVILEGES OWNED BY role [, ...]
>
> DROP seems like the wrong verb here. DROP is used for deleting objects,
> while REVOKE is used for removing permissions from them. REVOKE already
> has something similar:
>
> REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA public FROM heikki;
>
> Following that style, how about making the syntax:
>
> REVOKE ALL PRIVILEGES FROM <role>;

I don't have a problem with that.  It would probably work, too, since 
FROM is already fully reserved.


.marko