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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #17626: Permission denied errors should list role as well as user
Дата
Msg-id CAKFQuwa9HccMHPkdKnhcJouVXxCwcSnmGybfpDcWw3UFv2Bm7Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17626: Permission denied errors should list role as well as user  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #17626: Permission denied errors should list role as well as user
Список pgsql-bugs
On Mon, Oct 3, 2022 at 6:51 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
PG Bug reporting form <noreply@postgresql.org> writes:
> 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".

No ... it just looks like

regression=> select * from foo; -- errors
ERROR:  permission denied for table foo

Based on the subject line the proper wording would be "the error message should look some like ..."

Basically, a permission check requires two things and the complaint is that only one of those things is mentioned in the error message.

David J.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17626: Permission denied errors should list role as well as user
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17626: Permission denied errors should list role as well as user