Document target_role param of ALTER DEFAULT PRIVILEGES

From: Jordi Gutiérrez Hermoso <jordigh(at)octave(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Document target_role param of ALTER DEFAULT PRIVILEGES
Date: 2021-02-17 20:08:35
Message-ID: 72652d72e1816bfc3c05d40f9e0e0373d07823c8.camel@octave.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

I just had a confusing moment trying to figure out why my roles
weren't creating tables the way I was expecting them to. I didn't
understand what the `target_role` parameter did. No matter how I try
to read this page, I can't see an explanation for that parameter:

https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html

I propose an explanation like the following be added to the
`target_role` parameter:

This is the role that will create objects with altered default
privileges. Note that changes in default privileges aren't
inherited, so altering the default privileges of created objects
for a parent role will not change the default privileges of
objects created by inherited roles.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Laurenz Albe 2021-02-18 07:16:13 Re: Document target_role param of ALTER DEFAULT PRIVILEGES
Previous Message Tom Lane 2021-02-17 19:58:47 Re: Re: About the return states of SPI_execute for plpy.execute().status()