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" <coe...@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.
