Re: Create user mapping for role

Gerard Weatherby <gerardw(at)alum(dot)mit(dot)edu> writes:
> Can a foreign data wrapper user mapping by created for multiple users via a role? i.e. if bob, sally, and john belong to role foreigusers, is it possible to do something like
> Create user mapping for foreignusers server …

You can certainly create a user mapping for a role. But I think you'll
find that sally et al have to do "SET ROLE foreignusers" to use it.
It's difficult to see a way to avoid that --- after all, if sally is
also a member of foreignuserstoo that also has a mapping, which one
should the system use?

regards, tom lane