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

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces

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?

Brijesh Shrivastav

pgsql-interfaces by date

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

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