Postgres Pro
Downloads
Home   >   mailing lists

Re: Reg: User creation script/List of privileges - Mailing list pgsql-general

From Tomas Pospisek
Subject Re: Reg: User creation script/List of privileges
Date
Msg-id 3cd1d627-bfe4-9112-0327-2549909f750f@sourcepole.ch
Whole thread Raw
In response to Reg: User creation script/List of privileges  (Sai Ch <chspk2020@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: psql -f and PAGER
Next
From: Christoph Berg
Date:
Subject: PostgreSQL on focal and llvm version