You can use pg_dumpall -g to get user information for the cluster. Regards, Priyanka
On Thu, 12 Oct 2023 at 3:46 PM, Jana Mihalidesová <mihi.j...@seznam.cz> wrote: > 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 >
