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 по дате отправления: