Re: Extension vs Implementing Wire Protocol

On Mon, Jul 20, 2020 at 10:36:26PM +0200, Thomas Kellerer wrote:

> >   * 'SELECT * FROM table;' should return masked versions of the columns based on policy for that specific user.
> >   * 'SELECT * FROM table;' should return just the columns accessible to a specific user.
> >
> > Questions:
> >
> > 1. Are there easily extensible (ideally open-source) proxies that
> > already implement the Postgres protocol that we could modify/extend
> > to support this?
>
> You might want to look this extension:
>
> https://postgresql-anonymizer.readthedocs.io/en/latest/

or https://github.com/marcmunro/veil

Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B