Privileges query?

From: marcus(at)anywhere(dot)ws
To: pgsql-novice(at)postgresql(dot)org
Subject: Privileges query?
Date: 2006-05-16 02:18:25
Message-ID: 20060516021825.gk34j7pfyzkgowgg@anywhere.ws
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • Localization at 2006-05-16 17:55:15 from Valentin Gjorgjioski
  • Localization at 2006-05-16 18:03:52 from Valentin Gjorgjioski

Browse pgsql-novice by date

  From Date Subject
Next Message Verena Ruff 2006-05-16 08:31:57 tools analyzing EXPLAIN
Previous Message Jeff MacDonald 2006-05-15 23:26:15 Re: MySQL DB to PostgresSQL DB