Does the stansuser have connect privileges to the actual database where the schema and tables are? GRANT connect ON DATABASE <stans_whatever> TO stansuser; Note that since you didn’t tell us what the database name is here, you’ll need to substitute the actual name of it where I indicated <stans_whatever>. — Jay Sent from my iPad > On Dec 18, 2020, at 7:07 AM, Ron <ronljohnsonjr@xxxxxxxxx> wrote: > > 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. > >
