Обсуждение: About retrieving objects' priviledge info such as grantee & its privileges for a specific object (view, table, function, etc.)

Поиск
Список
Период
Сортировка
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