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.