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

Started by Ying Luover 20 years ago1 messagesgeneral
Jump to latest
#1Ying Lu
ying_lu@cs.concordia.ca

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