Filtering tables based on user privileges

Поиск
Список
Период
Сортировка
От Brijesh Shrivastav
Тема Filtering tables based on user privileges
Дата
Msg-id 491DC5F3D279CD4EB4B157DDD62237F401ADE497@zipwire.esri.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: libpq binary transfer of the numeric data type
Следующее
От: Brijesh Shrivastav
Дата:
Сообщение: Re: Filtering tables based on user privileges