I just want to confirm this statement:
As soon as a Desktop user can download a workbook from server, he/she is able to remove User Filters (row level security) and see all the data.
Is there a way of restricting users' ability to do that? We need to allow download access though.
We have a 'Business' user filter where people added to certain groups are only able to see the data corresponding to their own businesses.
Better publish with database prompt user login.
Whenever they download workbook it will ask db password to open the workbook and business user cannot get all data.