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. ?
pgsql-admin by date
|Next:||From: Robert Treat||Date: 2008-07-11 15:19:45|
|Subject: pitr standby on slave with skewed time|
|Previous:||From: niall el-assaad||Date: 2008-07-11 09:39:43|
|Subject: Password recommendations for an appliance|