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