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