| From: | Greg Stark <stark(at)mit(dot)edu> |
|---|---|
| To: | Nico Williams <nico(at)cryptonector(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Adam Brusselback <adambrusselback(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: generated columns |
| Date: | 2017-10-03 22:17:23 |
| Message-ID: | CAM-w4HMLjk6cdUcGxoViYDp8gBU_mf+5hr9aAeMAGvS5-yqL2w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vik Fearing | 2017-10-03 22:24:19 | Re: [PATCH] WIP Add ALWAYS DEFERRED option for constraints |
| Previous Message | Robert Haas | 2017-10-03 22:10:46 | Re: parallelize queries containing initplans |