Обсуждение: Row Level Security Policy question

Поиск
Список
Период
Сортировка

Row Level Security Policy question

От
Garry Chen
Дата:

Hi All,

                I have a question about PostgreSQL row level security policy.  Is it passable to have an “and“ condition inside using when create a policy?  For example ad following:

 

CREATE POLICY plc_sec_select_ omb_data ON combo_fc

FOR SELECT TO PUBLIC USING (row_type in (select row_type from sec_select_row_type())

                                                                and acct_nbr in (select acct_nbr from sec_select_acct_nbr()));

 

 

Garry