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.
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 |