Reg: User creation script/List of privileges

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