Re: Collumn level permissions ?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: stan <stanb(at)panix(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Collumn level permissions ?
Date: 2019-08-19 19:24:11
Message-ID: 6b418494-d849-bdc8-3bd0-bdaadcdc4095@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/19/19 12:17 PM, stan wrote:
> I do know a way to solve this. I could create a view "B" that is a view of
> tab;e "A" without column "C" on the select, and give a user permissions on
> B, but not on A, or at least I think that would work.
>
> What I specifically need to do is "hide" one column of a table from a set
> of users.
>
> Any better way to do this?

https://www.postgresql.org/docs/11/sql-grant.html

>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ubence Quevedo 2019-08-19 21:42:06 Can't install postgresql from official postgresql repo on RedHat 8?
Previous Message stan 2019-08-19 19:17:02 Collumn level permissions ?