samjmck
05/06/2022, 10:06 AMwith check
and using
for policies?Needle
05/06/2022, 10:06 AMgaryaustin
05/06/2022, 1:35 PMExisting table rows are checked against the expression specified in USING, while new rows that would be created via INSERT or UPDATE are checked against the expression specified in WITH CHECK. When a USING expression returns true for a given row then that row is visible to the user, while if false or null is returned then the row is not visible. When a WITH CHECK expression returns true for a row then that row is inserted or updated, while if false or null is returned then an error occurs.
Needle
05/06/2022, 1:35 PMNeedle
05/07/2022, 7:05 AM