Re: Proposal: two new role attributes and/or capabilities?

[snip]
So you want to say:

GRANT IMPERSONATE TO bouncer; --covers the "ALL" requirement

instead of

GRANT victim1 TO bouncer;
GRANT victim2 TO bouncer;
etc...

-- these would still be used to cover the "limited users" requirement
?

GRANT IMPERSONATE ON actual_role TO login_role

    would actually get us closer to how some other databases do, now that I think of it. This could be just some syntactic sugar.
    Might definitively ease migrations, if nothing else.


I appreciate the feedback. Thanks!


    / J.L.