We have migrated to new Google sites!
Post date: Jan 28, 2015 3:16:52 PM
There is a table in the gp_toolkit schema that list this information.
sachi=#
sachi=# \d gp_toolkit.gp_roles_assigned
View "gp_toolkit.gp_roles_assigned"
Column | Type | Modifiers
--------------+------+-----------
raroleid | oid |
rarolename | name |
ramemberid | oid |
ramembername | name |
View definition:
SELECT pgr.oid AS raroleid, pgr.rolname AS rarolename, pgam.member AS ramemberid, pgr2.rolname AS ramembername
FROM pg_roles pgr
LEFT JOIN pg_auth_members pgam ON pgr.oid = pgam.roleid
LEFT JOIN pg_roles pgr2 ON pgam.member = pgr2.oid;
sachi=#
sachi=# select * from gp_toolkit.gp_roles_assigned;
raroleid | rarolename | ramemberid | ramembername
----------+--------------+------------+--------------
88044 | admin | 16994 | sachi
10 | gpadmin | |
96279 | gpmon | |
16994 | sachi | |
33477 | gpuser | |
96285 | tev_bdasvc | |
96286 | ccuser | 96287 | tom
96286 | ccuser | 96287 | scott
(10 rows)
sachi=#