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

From: Ying Lu <ying_lu(at)cs(dot)concordia(dot)ca>
To: Pgsql-sql(at)postgresql(dot)org
Subject: About retrieving objects' priviledge info such as grantee & its privileges for a specific object (view, table, function, etc.)
Date: 2005-07-18 15:40:05
Message-ID: 42DBCD55.5080909@cs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Mark Fenbers 2005-07-18 16:50:54 Dumping table definitions
Previous Message daq 2005-07-18 13:32:08 Re: Create trigger for auto update function