Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Script to find which group roles are granted to the User

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

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

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

 pg_get_userbyid(roleid) AS GroupRoleName
 ,pg_get_userbyid(member) AS GrantedUserName
 ,pg_get_userbyid(grantor) AS GrantorUserName
 ,admin_option AS HasAdminOption
FROM pg_auth_members 
WHERE pg_get_userbyid(roleid) = 'User_Name';


Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

PostgreSQL Monitoring Tools

PostgreSQL pgBadger