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,