SQL Row level security

sql-row-level-security.sql

-- DROP FUNCTION [dbo].[fn_tenantSecurityPredicate]
CREATE FUNCTION [dbo].[fn_tenantSecurityPredicate](@tenantId UNIQUEIDENTIFIER)
	RETURNS TABLE
	WITH SCHEMABINDING
AS
	RETURN SELECT 1 AS [predicateResult]
		   FROM		[dbo].[Users] 
		   WHERE	[Username] = CURRENT_USER
		   AND		([TenantId] IS NULL OR ([TenantId] IS NOT NULL AND @tenantId = [TenantId]));
GO

-- DROP SECURITY POLICY [dbo].[tenantSecurityPolicy]
CREATE SECURITY POLICY [dbo].[tenantSecurityPolicy]
	ADD FILTER PREDICATE [dbo].[fn_tenantSecurityPredicate](TenantId) ON [dbo].[Customer],
	ADD FILTER PREDICATE [dbo].[fn_tenantSecurityPredicate](TenantId) ON [dbo].[Orders]
	WITH (STATE = ON);
GO