About retrieving objects' priviledge info such as grantee & its privileges for a specific object (view, table, function, etc.) - Mailing list pgsql-general

From Ying Lu
Subject About retrieving objects' priviledge info such as grantee & its privileges for a specific object (view, table, function, etc.)
Date
Msg-id 42DBED51.9090603@cs.concordia.ca
Whole thread Raw
List pgsql-general
Hello,

May I know the commands to retrieve objects' privileges info please?
Something like:


Object Type, Object name,    creator,    grantee,    privilege,
is_creatable
===================================================================
table      T1        user1     user2     select, update, delete        no
table      T1        user1     user3
select                                 no
view       V1       user2      user4
select                                 no

P.S. (postgreSQL 8.0.1)

Thanks a lot,
Emi

pgsql-general by date:

Previous
From: "Jim Buttafuoco"
Date:
Subject: Re: Error while vacuuming
Next
From: Tom Lane
Date:
Subject: Re: point(lseg,lseg) does not exist