Unanswered: Grant select access to view but not underlying table
I have got a table where different users are required to access only a subset of the table. Each user has its own postgres account.
My idea was to create different views with the corresponding WHERE statements and grant select access to the views for the users. But how do I prevent then that the users can directly query the source table?
So far I have not managed to allow access to the views but not the source table.