<div class="moz-cite-prefix">On 12/23/2014 07:01 PM, David G Johnston wrote:<br /></div><blockquote
cite="mid:1419357715258-5831868.post@n5.nabble.com"type="cite"><pre wrap="">[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
?</pre></blockquote><br /><code>GRANT IMPERSONATE ON actual_role TO login_role</code><br /><br /> would actually
getus closer to how some other databases do, now that I think of it. This could be just some syntactic sugar.<br />
Mightdefinitively ease migrations, if nothing else.<br /><br /><br /> I appreciate the feedback. Thanks!<br /><br /><br
/> / J.L.<br /><br />