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
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?
pgsql-interfaces by date
|Next:||From: Brijesh Shrivastav||Date: 2004-06-15 22:51:26|
|Subject: Re: Filtering tables based on user privileges|
|Previous:||From: Sitaram_Pamarthi||Date: 2004-06-15 05:19:28|
|Subject: Error in Installing pgsql_perl5|