Row-level security

RLS: Row-level security = restrict access to individual rows in a table
- Allows you to write custom logic to control user access to every row
- Security predicate function = ordinary inline schema-bound table-valued function whose parameters are mapped to column values

CREATE SECURITY POLICY sec.MyTablePolicyFilter
    ADD FILTER PREDICATE sec.fn_mySecurityPredicate(MyColumnName)
    ON dbo.MyTable
    WITH (STATE = ON)

Is this useful?