Re: Can user specification of a column value be required when querying a view ?

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Can user specification of a column value be required when querying a view ?
Дата
Msg-id CANzqJaBwVqMJoZEYjhqQjSW+EQNnv7aNy7vyLZiDszBUWm_Xsg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Can user specification of a column value be required when querying a view ?  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Ответы Re: Can user specification of a column value be required when querying a view ?
Список pgsql-general
Дерево обсуждения
On Fri, Nov 24, 2023 at 1:01 PM Peter J. Holzer <hjp-pgsql@hjp.at> wrote:
On 2023-11-20 22:03:06 -0500, Ron Johnson wrote:
> Or row level security.

Does that help here? AIUI row level security can be used to limit access
to specific rows (e.g. user alex can access info about ssn '106-91-9930'
but not '234-56-7890') but not how many rows can be accessed in a single
query.

I don't think OP indicated that ssn in a unique key. 

В списке pgsql-general по дате отправления:

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Can user specification of a column value be required when querying a view ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Odd Shortcut behaviour in PG14