Someone asked me how to list all tables that a given user can select from. They’ve got a special user for a client, so the client can make its own sql queries but due to the security policy, that user can only select and only from some tables. They wanted to give the client a list of tables that can be selected.
Let’s name the user: ’super_me’. Such a report can be generated using this simple query:

Mas:

http://www.simononsoftware.com/how-to-check-postgresql-privileges/