Re: "paths" between two ROLEs

2023-06-13 Thread Dominique Devienne
On Tue, Jun 13, 2023 at 2:20 PM Joe Conway wrote: > On 6/13/23 04:17, Dominique Devienne wrote: > > To troubleshoot and validate that emulation, I'd like to introspect ROLE > > membership to: > > > > 1) Output the ROLE "path(s)" between any two ROLEs.[...] > > 2) Output all target ROLEs [...] a g

Re: "paths" between two ROLEs

2023-06-13 Thread Joe Conway
On 6/13/23 04:17, Dominique Devienne wrote: Hi. We emulated a legacy security model (enforced in C/C++ code) into "layers" of PostgreSQL ROLEs and GRANTs, thus enforced database-side. To troubleshoot and validate that emulation, I'd like to introspect ROLE membership to: 1) Output the ROLE "p

"paths" between two ROLEs

2023-06-13 Thread Dominique Devienne
Hi. We emulated a legacy security model (enforced in C/C++ code) into "layers" of PostgreSQL ROLEs and GRANTs, thus enforced database-side. To troubleshoot and validate that emulation, I'd like to introspect ROLE membership to: 1) Output the ROLE "path(s)" between any two ROLEs. Typically between