Date: Wed, 10 Jun 2020 11:53:09 -0400
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: stephen@onethree.bio, pgsql-docs@lists.postgresql.org
Subject: Re: some charts or graphs of possible permissions would be nice
Message-ID: <20200610155309.GA13342@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <a872a78471a72e2bd1a3c66373c117ffef2ca86b.camel@cybertec.at>
User-Agent: Mutt/1.10.1 (2018-07-13)
Precedence: bulk

On 2020-Jun-10, Laurenz Albe wrote:

> On Tue, 2020-06-09 at 21:34 +0000, PG Doc comments form wrote:
> > Having read through the documentation on roles/granting I think I more or
> > less understand how it works, but what isn't really clarified is what the
> > overall universe of permissions that can be granted looks like. For example
> > I still didn't realize that to create a schema, you need to "GRANT CREATE"
> > to the role on the database before the role is allowed to do that. It's hard
> > to make a mental map of everything that a new role might need when I am
> > creating it.
> 
> That would be material for a tutorial rather than a documentation.

... but our documentation *does* have a tutorial, which could perhaps
gain a section about privileges.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services