On Fri, Jul 1, 2022 at 6:17 AM Joe Conway <m...@joeconway.com> wrote: > Would this allow for an explicit REVOKE to override a default INHERIT > along a specific path?
Can you give an example? If you mean that A is granted to B which is granted to C which is granted to D and you now want NOINHERIT behavior for the B->C link in the chain, this would allow that. You could modify the existing grant by saying either "REVOKE INHERIT OPTION FOR B FROM C" or "GRANT B TO C WITH INHERIT FALSE". -- Robert Haas EDB: http://www.enterprisedb.com
