On 7/28/22 8:03 PM, Robert Haas wrote:
Ok, Thanks, Robert. I tested with a couple of more scenarios like pg_upgrade/pg_dumpall /grant/revoke .. with admin option/inheritNo, it seems to me that's behaving as intended. REVOKE BLAH OPTION ... is intended to be a way of switching an option off.
and things look good to me.
-- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company