Re: List users privileges for whole cluster/all databases in the cluster

2023-10-12 Thread Dominique Devienne
On Thu, Oct 12, 2023 at 3:42 PM Jana Mihalidesová wrote: > 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 privil

Re: List users privileges for whole cluster/all databases in the cluster

2023-10-12 Thread Tom Lane
=?utf-8?q?Jana_Mihalidesov=C3=A1?= writes: > 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 u

Re: List users privileges for whole cluster/all databases in the cluster

2023-10-12 Thread Priancka Chatz
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á 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