| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Paul Jones <pbj(at)cmicdo(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Redacting JSONB |
| Date: | 2017-08-07 19:14:52 |
| Message-ID: | 03c2465b-4bef-bdc1-3723-ffd2f307bd56@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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. *****
| From | Date | Subject | |
|---|---|---|---|
| Next Message | anand086 | 2017-08-07 23:33:21 | Audit based on role |
| Previous Message | Paul Jones | 2017-08-07 19:08:07 | Redacting JSONB |