view to get all role privileges - Mailing list pgsql-novice

From Huang, Suya
Subject view to get all role privileges
Date
Msg-id D83E55F5F4D99B4A9B4C4E259E6227CDA0353F@AUX1EXC02.apac.experian.local
Whole thread Raw
Responses Re: view to get all role privileges
List pgsql-novice

Hello,

 

I’m using Greenplum 4.2.3.0 and did a backup/restore using gpcrondump. However, after it completed, I found some of the privileges are missing in the new database. for example, the privilege of a particular user to create schema in the database.

 

Can someone tell me which view in Postgresql is used to check all privileges granted to a specific user?

 

Thanks,

Suya

pgsql-novice by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: contrib module v 8.4 into 8.3.6 db
Next
From: Raghu Ram
Date:
Subject: Re: view to get all role privileges