From: Tom Lane <tgl@sss.pgh.pa.us>
To: Wells Oliver <wells.oliver@gmail.com>
cc: Holger Jakobs <holger@jakobs.com>, pgsql-admin@lists.postgresql.org
Subject: Re: Baffled by basic permission issue.
In-reply-to: 
 <CAOC+FBUvbGuZ5iY9bh8xCcrGt_fzMCfFJLkOfxn2bFypDuz1dg@mail.gmail.com>
References: 
 <CAOC+FBV5TxsJ4CHTo60TYGDNU0Y1eM=XzrzHJNmSgpyFLdmqMg@mail.gmail.com>
 <3AD88617-B7E7-4AF5-AE0B-05A79F88C2CC@jakobs.com>
 <CAOC+FBUvbGuZ5iY9bh8xCcrGt_fzMCfFJLkOfxn2bFypDuz1dg@mail.gmail.com>
Comments: In-reply-to Wells Oliver <wells.oliver@gmail.com>
	message dated "Wed, 16 Jun 2021 14:01:05 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <805162.1623878495.1@sss.pgh.pa.us>
Date: Wed, 16 Jun 2021 17:21:35 -0400
Message-ID: <805163.1623878495@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/805163.1623878495%40sss.pgh.pa.us>
Precedence: bulk

Wells Oliver <wells.oliver@gmail.com> writes:
> The role has SELECT perm on the view and on the underlying tables and I am
> received a permission denied table on the table while trying to select from
> the view. The view is owned by a different user but SELECT perms are very
> clearly granted to my role.

When you select from a view, you need permissions only on the view.
The view's owner needs permissions on the underlying table(s).
This is so that views can act as permission gateways.

			regards, tom lane