From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: User granted all access to schema, but can't see tables
Date: Fri, 18 Dec 2020 06:07:21 -0600
Message-ID: <0bfc7514-e4ee-375e-be44-24479e728adc@gmail.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com
Subject: Re: User granted all access to schema, but can't see tables
In-Reply-To: <0bfc7514-e4ee-375e-be44-24479e728adc@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox