List users privileges for whole cluster/all databases in the cluster
Jana Mihalidesová <mihi.jana@seznam.cz>
From: Jana Mihalidesová <Mihi.Jana@seznam.cz>
To: <pgsql-general@lists.postgresql.org>
Date: 2023-10-12T13:32:34Z
Lists: pgsql-general
Hi, I try to find out some view, select or something what show me the privileges for the user across the whole postgresql cluster. The username/user is global for whole cluster not individual database, so I would like to know the privileges for the user in all databases in the cluster using one view, select. I know how to list user's privileges in the individual database, but for all databases... Thanks for the advice. Jana