Discussion:
Row Level Security Policy question
Garry Chen
2018-03-12 15:39:50 UTC
Permalink
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

Loading...