Can more functions similar to dbo.tsf_user() be created?

Hi Rucha,

You could create a Function of your own that uses the dbo.tsf_user() function but incorporates the business logic that the end product requires. It depends a bit on how you determine to show data to users.

For example, a dbo.app_user() Table function with some code like this. It will return a list of all users that one users may see data for:

return (

select u.user_id
from user_table u
where u.user_id = dbo.tsf_user()
   or u.manager_id = dbo.tsf_user()
 --and so on
)

Now the function will return a list of users with which you can use for any purpose to determine which users’ data is visible to the logged-in person (tsf_user).

Prefilter example:

user_id in (select user_id
            from dbo.app_user())

Hope this gives a good idea 😄