Filtering tables based on user privileges

From: Brijesh Shrivastav <Bshrivastav(at)esri(dot)com>
To: "Pglibpq (E-mail)" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Filtering tables based on user privileges
Date: 2004-06-15 16:58:00
Message-ID: 491DC5F3D279CD4EB4B157DDD62237F401ADE497@zipwire.esri.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Brijesh Shrivastav 2004-06-15 22:51:26 Re: Filtering tables based on user privileges
Previous Message Sitaram_Pamarthi 2004-06-15 05:19:28 Error in Installing pgsql_perl5