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 <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.