Fine grained permissions on User Mapping

2020-06-02 Thread Paul Bonaud
Hello, I couldn't find any answer in the PostgreSQL documentation so here I am with a question regarding FDW and User Mappings. *Is it possible to define permissions on user mappings to hide the connection info (mainly the password) to a user?* More details of the context: Imagine you have a

Re: Fine grained permissions on User Mapping

2020-06-03 Thread Paul Bonaud
If I understand correctly, my initial question doesn't have a solution within postgres, does this sound right? Thanks again ! Paul On Tue, 2 Jun 2020 at 16:08, Tom Lane wrote: > Paul Bonaud writes: > > Imagine you have a destination database which you have no control over. > >

Re: Fine grained permissions on User Mapping

2020-06-04 Thread Paul Bonaud
's username and password. Thank you very much ! On Wed, 3 Jun 2020 at 22:22, Adrian Klaver wrote: > On 6/3/20 4:11 AM, Paul Bonaud wrote: > > Hi Tom, > > > > Thank you very much for your answer. > > > > I was worried to get this kind of solution, i.e. “don&#x