Microsoft SQL Server Row-level security Altering RLS security policy
Example
Security policy is a group of predicates associated to tables that can be managed together. You can add, or remove predicates or turn on/off entire policy.
You can add more predicates on tables in the existing security policy.
ALTER SECURITY POLICY dbo.CompanyAccessPolicy
ADD FILTER PREDICATE dbo.pUserCanAccessCompany(CompanyID) ON dbo.Company
You can drop some predicates from security policy:
ALTER SECURITY POLICY dbo.CompanyAccessPolicy
DROP FILTER PREDICATE ON dbo.Company
You can disable security policy
ALTER SECURITY POLICY dbo.CompanyAccessPolicy WITH ( STATE = OFF );
You can enable security policy that was disabled:
ALTER SECURITY POLICY dbo.CompanyAccessPolicy WITH ( STATE = ON );
