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
