Re: replacing role-level NOINHERIT with a grant-level option

postgres=# \dp+ atest2

                                           Access privileges

 Schema |  Name  | Type  |               Access privileges               | Column privileges | Policies 

--------+--------+-------+-----------------------------------------------+-------------------+----------

 public | atest2 | table | regress_priv_user1=arwdDxt/regress_priv_user1+|                   | 

        |        |       | regress_priv_user2=r/regress_priv_user1      +|                   | 

        |        |       | regress_priv_user3=w/regress_priv_user1      +|                   | 

        |        |       | regress_priv_user4=a/regress_priv_user1      +|                   | 

        |        |       | regress_priv_user5=D/regress_priv_user1       |                   | 

(1 row)

and found that after pg_upgrade there is no change on privileges  on v16(w/patch)

One scenario where the syntax is created in pg_dumpall is wrong 

postgres=# create user u1; 

CREATE ROLE

postgres=# create group g1 with user u1; 

CREATE ROLE

postgres=# grant g1 to u1 with admin option, inherit false;

GRANT ROLE

postgres=# 

Perform pg_dumpall

This is the syntax coming 

"

-- Role memberships

--

GRANT g1 TO u1 WITH ADMIN OPTION WITH INHERIT FALSE GRANTED BY edb;

"

If we run this syntax on psql, there is an error.

postgres=# GRANT g1 TO u1 WITH ADMIN OPTION WITH INHERIT FALSE GRANTED BY edb;

ERROR:  syntax error at or near "WITH"

regards,