On Tue, Aug 22, 2023 at 10:02:16AM +0300, Pavel Luzanov wrote: > On 22.08.2023 00:58, Bruce Momjian wrote: > > Attached is an applied patch that moves the inherit item into > > incompatibilities. clarifies it, and splits out the ADMIN syntax item. > > > The role's default inheritance behavior can be overridden with the new > <command>GRANT ... WITH INHERIT</command> clause. > > The only question about "can be". Why not "will be"? The inheritance > behavior will be changed anyway.
I used "can be" to highlight you "can" override it, but don't need to. > > Please let me know if I need any other changes. Thanks. > > * Allow psql's access privilege commands to show system objects (Nathan > Bossart, Pavel Luzanov) > The options are \dpS, \zS, and \drg. > > I think that this description correct only for the \dpS and \zS commands. > (By the way, unfortunately after reverting MAINTAIN privilege this commands > are not much useful in v16.) > > But the \drg command is a different thing. This is a full featured > replacement for "Member of" column of the \du, \dg commands. > It shows not only members, but granted options (admin, inherit, set) and > grantor. > This is important information for membership usage and administration. > IMO, removing the "Member of" column from the \du & \dg commands also > requires attention in release notes. > > So, I suggest new item in the psql section for \drg. Something like this: > > * Add psql \drg command to display role grants and remove the "Member of" > column from \du & \dg altogether. I see your point. Attached is an applied patch which fixes this by splitting \drg into a separate item and adding text. -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.
diff --git a/doc/src/sgml/release-16.sgml b/doc/src/sgml/release-16.sgml index 1f98ccdc62..c464be5ee1 100644 --- a/doc/src/sgml/release-16.sgml +++ b/doc/src/sgml/release-16.sgml @@ -2176,11 +2176,28 @@ Author: Tom Lane <t...@sss.pgh.pa.us> <listitem> <para> -Allow <application>psql</application>'s access privilege commands to show system objects (Nathan Bossart, Pavel Luzanov) +Add <application>psql</application> command <link linkend="app-psql-meta-command-drg"><command>\drg</command></link> to show role membership details (Pavel Luzanov) </para> <para> -The options are <link linkend="app-psql-meta-command-dp-lc"><command>\dpS</command></link>, <link linkend="app-psql-meta-command-z"><command>\zS</command></link>, and <link linkend="app-psql-meta-command-drg"><command>\drg</command></link>. +The <literal>Member of</literal> output column has been removed from <command>\du</command> and <command>\dg</command> because this new command displays this informaion in more detail. +</para> +</listitem> + +<!-- +Author: Dean Rasheed <dean.a.rash...@gmail.com> +2023-01-07 [d913928c9] psql: Add support for \dpS and \zS. +Author: Tom Lane <t...@sss.pgh.pa.us> +2023-07-19 [d65ddaca9] Add psql \drg command to display role +--> + +<listitem> +<para> +Allow <application>psql</application>'s access privilege commands to show system objects (Nathan Bossart) +</para> + +<para> +The options are <link linkend="app-psql-meta-command-dp-lc"><command>\dpS</command></link> and <link linkend="app-psql-meta-command-z"><command>\zS</command></link>. </para> </listitem>
