Separate Point Queries and Listing for Permissions

Hello!

I think it would be great to be able to separate permissions to perform point queries (based on the primary key for example) and listing rows. This would be equivalent to the get/list permissions in Firebase. For example, for a user's table, I may want the user to be able to read any data of a user I have the id, but not be able to list all the users.

Basically, I want to allow queries like those:



But not like those:



Right now it is impossible to do it without Postgres functions, and it is impossible to use this technique for storage.