Wells Oliver <wells.oliver@xxxxxxxxx> 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
