Re: [GENERAL] Redacting JSONB

2017-08-07 Thread Joshua D. Drake

On 08/07/2017 12:08 PM, Paul Jones wrote:

Is there some way to redact JSONB fields? This is essentially implementing
"row-level" security on JSONB fields.  Could possibly be done with a
view or a function.  MongoDB and MarkLogic both do this.


Yeah I imagine you would use a view or function and only give access to 
the json data via that view or function. Pretty standard way of handling 
things like this.


JD



PJ





--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc

PostgreSQL Centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://pgconf.us
* Unless otherwise stated, opinions are my own.   *


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] Redacting JSONB

2017-08-07 Thread Paul Jones
Is there some way to redact JSONB fields? This is essentially implementing
"row-level" security on JSONB fields.  Could possibly be done with a
view or a function.  MongoDB and MarkLogic both do this.

PJ


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general