From: | Paul Jungwirth <pj(at)illuminatedcomputing(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Postgres Permissions Article |
Date: | 2017-03-28 16:47:40 |
Message-ID: | 7b84540f-cbce-83ab-b249-eb3526e3a9c3@illuminatedcomputing.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-03-28 18:23:58 | Re: Issue in autovacuum |
Previous Message | David G. Johnston | 2017-03-28 15:29:39 | Re: Request to add feature to the Position function |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2017-03-28 16:54:09 | Re: Partition-wise join for join between (declaratively) partitioned tables |
Previous Message | Dave Page | 2017-03-28 16:47:04 | Re: Monitoring roles patch |