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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Ying Lu
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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings