Re: \dp privileges "decoder" dropped in v12 of docs

2021-11-12 Thread Bruce Momjian 
On Thu, Nov 11, 2021 at 09:24:21PM +, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/13/sql-grant.html
> Description:
> 
> Hello, I'm wondering why this version of the GRANT doc has the \dp privilege
> definitions - https://www.postgresql.org/docs/9.3/sql-grant.html - but it's
> no longer available in v13 of the docs, which i'm actually trying to use -
> https://www.postgresql.org/docs/13/sql-grant.html
> 
> It seems that the section that has all of the definitions of the "privilege"
> letters was dropped in v12. Was that just an oversight? Where can I find
> that info nowadays?

It was moved in this commit:

commit afc4a78a30
Author: Tom Lane 
Date:   Mon Dec 3 11:40:49 2018 -0500

Refactor documentation about privileges to centralize the info.

Expand section 5.6 "Privileges" to include the full definition of
each privilege type, and an explanation of aclitem privilege 
displays,
along with some helpful summary tables.  Most of this material came
out of the GRANT reference page, although some of it is new.
Adjust a bunch of links that were pointing to GRANT to point to 5.6.

Fabien Coelho and Tom Lane, reviewed by Bradley DeJong

Discussion: 
https://postgr.es/m/alpine.DEB.2.21.1807311735200.20743@lancre

to a more appropriate place in the documentation:

https://www.postgresql.org/docs/14/ddl-priv.html

-- 
  Bruce Momjian  https://momjian.us
  EDB  https://enterprisedb.com

  If only the physical world exists, free will is an illusion.

\dp privileges "decoder" dropped in v12 of docs

2021-11-12 Thread PG Doc comments form 
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/sql-grant.html
Description:

Hello, I'm wondering why this version of the GRANT doc has the \dp privilege
definitions - https://www.postgresql.org/docs/9.3/sql-grant.html - but it's
no longer available in v13 of the docs, which i'm actually trying to use -
https://www.postgresql.org/docs/13/sql-grant.html

It seems that the section that has all of the definitions of the "privilege"
letters was dropped in v12. Was that just an oversight? Where can I find
that info nowadays?

To clarify, the section I'm talking about is this one:

---snip---
The entries shown by \dp are interpreted thus:

rolename= -- privileges granted to a role
= -- privileges granted to PUBLIC

r -- SELECT ("read")
w -- UPDATE ("write")
a -- INSERT ("append")
d -- DELETE
D -- TRUNCATE
x -- REFERENCES
t -- TRIGGER
X -- EXECUTE
U -- USAGE
C -- CREATE
c -- CONNECT
T -- TEMPORARY
  arwdDxt -- ALL PRIVILEGES (for tables, varies for other objects)
* -- grant option for preceding privilege

/ -- role that granted this privilege
---snip---

Thanks!
Inger