Postgres Permissions Article

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

Responses

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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