User granted all access to schema, but can't see tables
От | Ron |
---|---|
Тема | User granted all access to schema, but can't see tables |
Дата | |
Msg-id | 0bfc7514-e4ee-375e-be44-24479e728adc@gmail.com обсуждение исходный текст |
Ответы |
Re: User granted all access to schema, but can't see tables
|
Список | 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.
В списке pgsql-admin по дате отправления: