pgsql: Add TAP tests for role membership in pg_hba.conf - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Add TAP tests for role membership in pg_hba.conf
Date
Msg-id E1oi7KS-001qcT-0Z@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Add TAP tests for role membership in pg_hba.conf

This commit expands the coverage of pg_hba.conf with checks specific to
role memberships (one "root" role combined with a member and a
non-member).  Coverage is added for the database keywords "samegroup"
and "samerole", where the specified role has to be be a member of the
role with the same name as the requested database, and '+' on the user
entry, where members are allowed.  These tests are plugged in the
authentication test 001_password.pl as of extra connection attempts
combined with resets of pg_hba.conf, making them rather cheap.

Author: Nathan Bossart
Reviewed-by: Tom Lane, Michael Paquier
Discussion: https://postgr.es/m/20221009211348.GB900071@nathanxps13

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/8432a815feb8897aabe0c6ed59f32bc47a6b2d50

Modified Files
--------------
src/test/authentication/t/001_password.pl | 126 ++++++++++++++++++++++++++++++
1 file changed, 126 insertions(+)


pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: Add support for COPY TO callback functions
Next
From: Amit Kapila
Date:
Subject: pgsql: Add a common function to generate the origin name.