@andycadley
Can i ask that if i wanted to apply the policy to multiple tables (Vw_Sec_Sales and Vw_Sec_Orders), would the best way to this?
I'm sure it is in this command and i am trying to add another line for add filter or add an AND after the ON statement,
CREATE SECURITY POLICY RowLeveSecurity_Brazil_SalesFilter
ADD FILTER PREDICATE RowLeveSecurity_Brazil.fn_securitypredicate(SalesRep)
ON [dbo].[Vw_Sec_Sales]
WITH (STATE = ON);