Re: view to get all role privileges

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?

 

=> \dp mytable                             Access privilegesSchema |  Name   | Type  |   Access privileges   | Column access privileges 
--------+---------+-------+-----------------------+--------------------------public | mytable | table | miriam=arwdDxt/miriam | col1:                         : =r/miriam             :   miriam_rw=rw/miriam                         : admin=arw/miriam        
(1 row)

The entries shown by \dp are interpreted thus:

rolename=xxxx -- privileges granted to a role       =xxxx -- privileges granted to PUBLIC
           r -- SELECT ("read")           w -- UPDATE ("write")           a -- INSERT ("append")           d -- DELETE           D -- TRUNCATE           x -- REFERENCES           t -- TRIGGER           X -- EXECUTE           U -- USAGE           C -- CREATE           c -- CONNECT           T -- TEMPORARY     arwdDxt -- ALL PRIVILEGES (for tables, varies for other objects)           * -- grant option for preceding privilege
       /yyyy -- role that granted this privilege