view to get all role privileges

From: "Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: view to get all role privileges
Date: 2013-11-07 04:35:44
Message-ID: D83E55F5F4D99B4A9B4C4E259E6227CDA0353F@AUX1EXC02.apac.experian.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Raghu Ram 2013-11-07 04:49:42 Re: view to get all role privileges
Previous Message Kevin Grittner 2013-11-05 21:20:54 Re: contrib module v 8.4 into 8.3.6 db