how to reset user settings

We built a multi tenant application like your sass example, everything works so far.

To automate our testing we are looking for a solution to reset the user settings like selected columns, column ordering, filter or everything what leads into capturing any state.

Which tables has to be truncated?

SEC_USER_SETTING

You can find the whole data model description in the Help > Data Model menu item in your running application.