Privileges query? - Mailing list pgsql-novice

From marcus@anywhere.ws
Subject Privileges query?
Date
Msg-id 20060516021825.gk34j7pfyzkgowgg@anywhere.ws
Whole thread Raw
Responses Localization
Localization
List pgsql-novice
Hi all,
I'm trying to see what privileges are assigned to tables/views for
specific group or user. But when I run the query -
select c.table_name,c.grantee,c.privilege_type from
information_schema.role_table_grants c;
it only returns the result for group that current user belongs to.
Is it possible to query from a specific user to see ALL users and
their privileges?



thanks.

Marcus

pgsql-novice by date:

Previous
From: "Robert Landsmeer"
Date:
Subject: Re: Wondering if anyone could help me
Next
From: Verena Ruff
Date:
Subject: tools analyzing EXPLAIN