To: pgsql-admin <pgsql-admin@postgresql.org>
From: Ron <ronljohnsonjr@gmail.com>
Subject: User granted all access to schema, but can't see tables
Message-ID: <0bfc7514-e4ee-375e-be44-24479e728adc@gmail.com>
Date: Fri, 18 Dec 2020 06:07:21 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.10.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk

This is v12 from RHEL repos.

As user postgres, I run:

sides=# grant all on SCHEMA strans TO stransuser;
GRANT

sides=# ALTER DEFAULT PRIVILEGES IN SCHEMA strans GRANT all on tables to 
stransuser;
ALTER DEFAULT PRIVILEGES

sides=# GRANT USAGE ON SCHEMA strans TO stransuser;
GRANT

But user stransuser still can’t access tables

sides=> \d
              List of relations
Schema |    Name    |   Type   |  Owner
--------+------------+----------+----------
strans | foo        | table    | postgres
strans | foo_id_seq | sequence | postgres
(2 rows)

sides=> select * from strans.foo;
ERROR:  permission denied for table foo

sides=> \z strans.foo
                                 Access privileges
Schema | Name | Type  |     Access privileges     | Column privileges | Policies
--------+------+-------+---------------------------+-------------------+----------
strans | foo  | table | postgres=arwdDxt/postgres+|                   |
        |      |       | READWRITE=arwdD/postgres +|                   |
        |      |       | READONLY=r/postgres |                   |
(1 row)

What am I missing?

-- 
Angular momentum makes the world go 'round.