pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feed\dp privileges "decoder" dropped in v12 of docs
2+ messages / 2 participants
[nested] [flat]
* \dp privileges "decoder" dropped in v12 of docs
@ 2021-11-11 21:24 PG Doc comments form <noreply@postgresql.org>
2021-11-12 14:20 ` Re: \dp privileges "decoder" dropped in v12 of docs Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2021-11-11 21:24 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: ingernet@gmail.com
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: \dp privileges "decoder" dropped in v12 of docs
2021-11-11 21:24 \dp privileges "decoder" dropped in v12 of docs PG Doc comments form <noreply@postgresql.org>
@ 2021-11-12 14:20 ` Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2021-11-12 14:20 UTC (permalink / raw)
To: ingernet@gmail.com; pgsql-docs@lists.postgresql.org; +Cc: Tom Lane <tgl@sss.pgh.pa.us>
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-11-12 14:20 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-11-11 21:24 \dp privileges "decoder" dropped in v12 of docs PG Doc comments form <noreply@postgresql.org>
2021-11-12 14:20 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox