...
Create Function fn_securitypredicate (@ACCT_NBR sysname)
returns table with Schemabinding
as
return select 1 as [fn_securityPredicate_result]
...
Create security Policy dbo.fn_security
add Filter Predicate dbo.fn_securitypredicate(ACCT_NBR) on dbo.orders
WITH (STATE = ON, SCHEMABINDING = ON)
Testing Result
EXECUTE AS USER = 'bb57';
...