I would like to know the best way of filtering data in an application based user ID.
In my case I some users that should be filtered and the rest should see all. The users being filtered aren’t that many (5-15) and they don’t change often (but our ‘see all’ users change more often). I also have a table with Userid that I can use for filtering, so they should only see data related to their Userid.
I understand that one option is section access. Is this the best option, or are there others?
Do I need to script and where do I place the script?