Re[2]: doc - improve description of default privileges

Hi Fabien,

Thanks for writing this up - in particular the psql backslash commands.

comments on the patch ...

1) I think that adding the "This privilege is abbreviated ... when 
displayed." lines to the privilege descriptions is redundant. The 
abbreviations are already listed after the "The entries shown by \dp are 
interpreted thus:" line. Just change that line to something like "The 
entries shown by the psql backslash commands, like \dp, are interpreted 
thus:".

2) I think that the psql command table should go with the current text 
on "Use psql's \dp command to obtain ..." rather than in the Examples 
section. It seems like changing the "For non-table objects there are 
other \d commands ..." line to an introductory comment like "The 
following table lists the \d commands that are used for non-table 
objects along with the default privileges granted to the object's owner 
and PUBLIC.

3) The table title, "Default hardcoded access privileges per object's 
type", seems incomplete because it does not mention the psql commands 
part of the table.


------ Original Message ------
From: "Fabien COELHO" <coelho@cri.ensmp.fr>
To: "PostgreSQL Developers" <pgsql-hackers@lists.postgresql.org>
Sent: 8/4/2018 4:40:33 AM
Subject: Re: doc - improve description of default privileges

>
>>I have not found a convenient presentation of the default privileges 
>>for different objects, and how to display them (if possible, not 
>>always).
>>
>>The information is partly provided within the GRANT description, and 
>>not very explicit: eg it is said that owners have all possible perms, 
>>but which they are is not said explicitely, although they are implied 
>>by the different GRANT sysnopsys. Then some objects are given perms 
>>for the PUBLIC.
>>
>>The attached patch tries to improve the documentation, in particular 
>>with an added table to summarizes my findings, so that they are 
>>recorded somewhere.
>
>The attached fixes the tablespace entry that I forgot to fill in full.
>
>-- Fabien.