Filtering tables based on user privileges - Mailing list pgsql-interfaces

From Brijesh Shrivastav
Subject Filtering tables based on user privileges
Date
Msg-id 491DC5F3D279CD4EB4B157DDD62237F401ADE497@zipwire.esri.com
Whole thread Raw
List pgsql-interfaces
Hi! 

I have a need to filter out tables that have specfic privileges for a user.
For example, select
all tables where user 'joe' has 'select' and 'insert' privileges. Can I
somehow filter
that at SQL level or will I have to get all non-system rows from pg_class
and filter it
one by one? How can I use whre clause against aclitem[] array?

Regards,
Brijesh Shrivastav


pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: libpq binary transfer of the numeric data type
Next
From: Brijesh Shrivastav
Date:
Subject: Re: Filtering tables based on user privileges