Ultimate access to all questions.
You have an Azure Synapse Analytics dedicated SQL pool named Pool1 containing a table named Sales. Row-level security (RLS) is applied to the Sales table with the following predicate filter:
CREATE FUNCTION Security.fn_securitypredicate(@SalesRep AS sysname)
RETURNS TABLE
WITH SCHEMABINDING
AS
RETURN SELECT 1 AS fn_securitypredicate_result
WHERE @SalesRep = USER_NAME() OR USER_NAME() = 'Manager';
GO
CREATE SECURITY POLICY SalesFilter
ADD FILTER PREDICATE Security.fn_securitypredicate(SalesRep)
ON dbo.Sales
WITH (STATE = ON);
A user named SalesUser1 is assigned the db_datareader
role for Pool1.
Which rows from the Sales table will be returned when SalesUser1 executes a query against it?