Re: Collumn level permissions ? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Collumn level permissions ?
Date
Msg-id 6b418494-d849-bdc8-3bd0-bdaadcdc4095@aklaver.com
Whole thread Raw
In response to Collumn level permissions ?  (stan <stanb@panix.com>)
List 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.klaver@aklaver.com



pgsql-general by date:

Previous
From: stan
Date:
Subject: Collumn level permissions ?
Next
From: Ubence Quevedo
Date:
Subject: Can't install postgresql from official postgresql repo on RedHat 8?