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 find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

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

vacuumlo - removing large objects orphans from a database PostgreSQL

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory