[ppa-commit] [phppgadmin/phppgadmin] 076f9f: Consider group membership when testing owned_only

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

  Branch: refs/heads/master
  Home:   https://github.com/phppgadmin/phppgadmin
  Commit: 076f9f54225079e0117227481fbe22f2dff81687
      https://github.com/phppgadmin/phppgadmin/commit/076f9f54225079e0117227481fbe22f2dff81687
  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