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.