Postgres Pro
Downloads
Home   >   mailing lists

Re: replacing role-level NOINHERIT with a grant-level option - Mailing list pgsql-hackers

From tushar
Subject Re: replacing role-level NOINHERIT with a grant-level option
Date
Msg-id 030c1dbf-5a8e-706d-698c-b1cdfcb6ce0f@enterprisedb.com
Whole thread Raw
In response to Re: replacing role-level NOINHERIT with a grant-level option  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: replacing role-level NOINHERIT with a grant-level option
List pgsql-hackers
Tree view 
On 7/28/22 8:03 PM, Robert Haas wrote:
> No, it seems to me that's behaving as intended. REVOKE BLAH OPTION ...
> is intended to be a way of switching an option off.
Ok, Thanks, Robert. I tested with a couple of more scenarios like 
pg_upgrade/pg_dumpall /grant/revoke .. with admin option/inherit
and things look good to me.

-- 
regards,tushar
EnterpriseDB  https://www.enterprisedb.com/
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: doc phrase: "inheritance child"
Next
From: Tom Lane
Date:
Subject: Re: Support for grabbing multiple consecutive values with nextval()