PostgreSQL: Script to find which group roles are granted to the User

In this post, I am sharing in one script to find which group roles are granted to user in PostgreSQL.

As a DBA, when you are managing a number of database users and connections at that time it is very important to find a list of assigned roles for different user.

Using this single script you can easily find a list of users and its assigned roles.

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz