Karsten Hilbert <Karsten.Hilbert@xxxxxxx> writes: > I expected this: > set role "restricted-role"; > -- this works: > select public_col from t_partially_private; > -- this fails: with "permission denied on table t_partially_private" > select public_col from v_partially_private; > to work but selecting from the view fails. Works fine if you don't mess with the view's security_invoker status. regards, tom lane
