User granted all access to schema, but can't see tables

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: User granted all access to schema, but can't see tables
Date: 2020-12-18 12:07:21
Message-ID: 0bfc7514-e4ee-375e-be44-24479e728adc@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2020-12-18 12:26:30 Re: User granted all access to schema, but can't see tables
Previous Message Laurenz Albe 2020-12-18 11:55:34 Re: Replication failed