Access rule listing from the whole database cluster

Поиск
Список
Период
Сортировка
От Dev
Тема Access rule listing from the whole database cluster
Дата
Msg-id 448146.59257.qm@web53702.mail.re2.yahoo.com
обсуждение исходный текст
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "niall el-assaad"
Дата:
Сообщение: Password recommendations for an appliance
Следующее
От: Robert Treat
Дата:
Сообщение: pitr standby on slave with skewed time