Re: [HACKERS] generated columns - Mailing list pgsql-hackers

From Greg Stark
Subject Re: [HACKERS] generated columns
Date
Msg-id CAM-w4HMLjk6cdUcGxoViYDp8gBU_mf+5hr9aAeMAGvS5-yqL2w@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] generated columns  (Nico Williams <nico@cryptonector.com>)
List pgsql-hackers
There are some unanswered questions with column grants too. Do we
allow granting access to a calculated column which accesses columns
the user doesn't have access to?

If so then this is a suitable substitute for using updateable views to
handle things like granting users access to things like password
hashes or personal data with details censored without giving them
access to the unhashed password or full personal info.

-- 
greg


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

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] parallelize queries containing initplans
Next
From: Vik Fearing
Date:
Subject: Re: [HACKERS] [PATCH] WIP Add ALWAYS DEFERRED option for constraints