Viewing Users and Groups (Roles)

posted Apr 28, 2017, 4:24 PM by Sachchida Ojha
Viewing Users and Groups (Roles)

It is frequently convenient to group users (roles) together to ease management of object privileges: that way, privileges can be granted to, or revoked from, a group as a whole. In Greenplum Database this is done by creating a role that represents the group, and then granting membership in the group role to individual user roles.

The gp_roles_assigned view can be used to see all of the roles in the system, and their assigned members (if the role is also a group role).

For example

select * from gp_toolkit.gp_roles_assigned ;

List all views

select * from pg_views;

select * from pg_views where  viewname like 'gp%';