Re: Reg: User creation script/List of privileges

From: Tomas Pospisek <tpo2(at)sourcepole(dot)ch>
To: Sai Ch <chspk2020(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Reg: User creation script/List of privileges
Date: 2022-03-30 16:19:59
Message-ID: 3cd1d627-bfe4-9112-0327-2549909f750f@sourcepole.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 30.03.22 05:09, Sai Ch wrote:
> Hi Experts,
>
> I am looking for a query or possibility to generate all the privileges a
> user/role has.
>
> I need this to create a user/role from one database to another with
> exact same privileges.
>
> Kindly, share the query or way to proceed further.
>
> Thanks & Regards,

Maybe have a look at
https://github.com/tpo/little_shell_scripts/blob/master/psql_access_priv_decoder

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Berg 2022-03-31 14:01:27 PostgreSQL on focal and llvm version
Previous Message Peter J. Holzer 2022-03-30 06:57:52 Re: psql -f and PAGER