Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE FUNCTION Security.fn_securitypredicate(@ParentEmployeeKey AS INT)
- RETURNS TABLE
- WITH SCHEMABINDING
- AS RETURN SELECT 1 AS fn_securitypredicate_result
- WHERE @ParentEmployeeKey = (SELECT EmployeeKey
- FROM dbo.DimMgr WHERE LoginID = Session_Context(N'user_id'));
- -- Note Session_Context(N'user_id')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement