Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group