On 16 October 2014 20:37, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
>> How about
>>
>> GRANT EXECUTE [PRIVILEGES] ON CAPABILITY foo TO bar;
>>
>> That is similar to granting execution privs on a function. And I think
>> gets round the keyword issue?
>
> No, it doesn't.. EXECUTE isn't reserved at all.
Yet GRANT EXECUTE is already valid syntax, so that should work.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services