Reg: User creation script/List of privileges

2022-03-30 Thread Sai Ch 
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,
Sai.

Re: Reg: User creation script/List of privileges

2022-03-30 Thread Tomas Pospisek 

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