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

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 42DBCD55.5080909@cs.concordia.ca
Whole thread Raw
List pgsql-sql
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-sql by date:

Previous
From: daq
Date:
Subject: Re: Create trigger for auto update function
Next
From: "Mark Fenbers"
Date:
Subject: Dumping table definitions