Postgres Permissions Article

Paul A Jungwirth <pj@illuminatedcomputing.com>

From: Paul Jungwirth <pj@illuminatedcomputing.com>
To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2017-03-28T16:47:40Z
Lists: pgsql-hackers, pgsql-general
Hi All,

I wrote a blog post about the Postgres permissions system, and I thought 
I'd share:

http://illuminatedcomputing.com/posts/2017/03/postgres-permissions/

The main point I wanted to convey, which I somehow never grasped 
confidently from reading the docs or other articles, is how permissions 
are purely additive. Also I wanted to gather in one place how to *see 
the current permissions*, which seems to be missing/incomplete in many 
other articles. Anyway, maybe it will be helpful for some of you! Or for 
the true experts, if you see any errors, I'd be happy to know so I can 
correct them.

I also shared a few opinions amidst the facts (like that `USAGE` for 
schemas doesn't add much), so I am very pleased to have those 
challenged. You can consider them my own outstanding questions. I'd be 
especially grateful for any feedback there.

Yours,
Paul


Commits

  1. For foreign keys, check REFERENCES privilege only on the referenced table.