Sample Header Ad - 728x90

Using whole row in Row Level Security policy

0 votes
1 answer
88 views
I am using row level security with function, for example
CREATE POLICY person_select_policy ON core.person FOR SELECT USING (core.person_policy_check(id, 'read') = TRUE);
Is it possible to pass **whole row** to the function? So the function would have access to all columns of the row without having to name them all as arguments. That way the function could accept core.person as parameter or at least a record type.
Asked by YangombiUmpakati (107 rep)
Dec 8, 2022, 10:29 AM
Last activity: Dec 8, 2022, 10:33 AM