BUG #17626: Permission denied errors should list role as well as user

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #17626: Permission denied errors should list role as well as user
Дата
Msg-id 17626-644f053cc20e1ba3@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #17626: Permission denied errors should list role as well as user
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      17626
Logged by:          Loren Siebert
Email address:      loren@paradigm.xyz
PostgreSQL version: 14.5
Operating system:   Debian
Description:

I'm running this set of commands:
create user elevated_user IN ROLE pg_read_all_data;
create user regular_user;
create table foo (id int);
set role elevated_user;
select * from foo; -- works
set role regular_user;
select * from foo; -- errors

The error message looks like "user=elevated_user ERROR:  permission denied
for table foo".
In fact, that user does have permission to access the table. But the
regular_role it has just assumed does not.
I would suggest that the error message look like "user=elevated_user,
role=regular_user ERROR:  permission denied for table foo"


В списке pgsql-bugs по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Bug / Unintentional Feature: non-immutable functions can be used for generated columns.
Следующее
От: Shane Plesner
Дата:
Сообщение: Re: Bug / Unintentional Feature: non-immutable functions can be used for generated columns.