[ppa-commit] [phppgadmin/phppgadmin] 3022b7: Consider group membership when testing owned_only

[Robert T. <no...@gi...>]

  Branch: refs/heads/102_owned_only
  Home:   https://github.com/phppgadmin/phppgadmin
  Commit: 3022b7a8dd91ccb2736c659cba174a774b6e4fb4
      https://github.com/phppgadmin/phppgadmin/commit/3022b7a8dd91ccb2736c659cba174a774b6e4fb4
  Author: Robert Treat <ro...@xz...>
  Date:   2020-10-28 (Wed, 28 Oct 2020)

  Changed paths:
    M classes/database/Postgres.php

  Log Message:
  -----------
  Consider group membership when testing owned_only

Based on code and suggestions from @cathysax, ultimately I used the internal
pg_has_role function to test whether a user has ownership rights based on
group membership. I actually check for 'USAGE' rights, since that implies the
role has rights without need to `set role`, which users wouldn't be able to do
with a normal PPA login. Loosely tested back to 9.5.
This fixes https://github.com/phppgadmin/phppgadmin/issues/102