Row Level Security Policy question - Mailing list pgsql-novice

From Garry Chen
Subject Row Level Security Policy question
Date
Msg-id EF58FF61-E3FF-4217-A935-91A56666CDEF@cornell.edu
Whole thread Raw
List pgsql-novice

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

pgsql-novice by date:

Previous
From: "Dale Schmitz"
Date:
Subject: Log in errors
Next
From: Dale Schmitz
Date:
Subject: Re: Error handling