Marc Balmer <marc(at)msys(dot)ch> writes:
> I have two login roles, user_A and admin_A, and a group role, group_A.
> user_A is member of group_A
> I create a table t_data, owned by admin_A
> I create a view v_data, owned by admin_A
> Now I grant SELECT privilege on view v_data to group_A
> I would by now assume that user_A can SELECT data on v_data, but he can
> not.
Maybe you should show us exactly what you did, rather than a handwavy
description of what you think you did. The exact error message would
be handy too.
regards, tom lane