Обсуждение: \dp privileges "decoder" dropped in v12 of docs

Поиск
Список
Период
Сортировка

\dp privileges "decoder" dropped in v12 of docs

От
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=xxxx -- privileges granted to a role
        =xxxx -- 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

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

Thanks!
Inger

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

От
Bruce Momjian
Дата:
On Thu, Nov 11, 2021 at 09:24:21PM +0000, 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 <tgl@sss.pgh.pa.us>
    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  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

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