| Hi, Is there any way in Postgres to get a list of all the databases and tables which are readable( Select granted ) for a particular user with a single SQL query ? I'm able to get information of all the databases on the cluster owned by a user from the pg_database and pg_roles structures. I'm also able to get acls granted in a particular database table using information_schema.role_table_grants. Is it possible to do this kind of querying across all databases hosted on the cluster without having to connect to each and query them. ? /Dev |
