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

PostgreSQL pgBadger

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

Migrating From Oracle to PostgreSQL using ora2pg open source tools

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

How to configure Replication Manager (repmgr) ?