pgsql: Add TAP tests for role membership in pg_hba.conf

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add TAP tests for role membership in pg_hba.conf
Date: 2022-10-11 04:57:20
Message-ID: E1oi7KS-001qcT-0Z@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Amit Kapila 2022-10-11 05:21:14 pgsql: Add a common function to generate the origin name.
Previous Message Michael Paquier 2022-10-11 02:47:56 pgsql: Add support for COPY TO callback functions