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-general(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 17:56:33
Message-ID: 42DBED51.9090603@cs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-07-18 17:59:42 Re: point(lseg,lseg) does not exist
Previous Message Jim Buttafuoco 2005-07-18 17:51:19 Re: Error while vacuuming