# How to set add/edit data in automatically generated user\_ex and user\_sa tables

**URL:** <https://forum.inductiveautomation.com/t/how-to-set-add-edit-data-in-automatically-generated-user-ex-and-user-sa-tables/94474>\
**Category:** Ignition\
**Tags:** database, ignition81, scripting, perspective\
**Created:** [August 11, 2024, 4:30pm UTC](https://forum.inductiveautomation.com/t/how-to-set-add-edit-data-in-automatically-generated-user-ex-and-user-sa-tables/94474 "2024-08-11T16:30:07Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lokmen\_Farhat](https://avatars.discourse-cdn.com/v4/letter/l/85f322/32.png) [@Lokmen\_Farhat](https://forum.inductiveautomation.com/u/Lokmen_Farhat)\
**Post date:** [August 11, 2024, 4:30pm UTC](https://forum.inductiveautomation.com/t/how-to-set-add-edit-data-in-automatically-generated-user-ex-and-user-sa-tables/94474/1 "2024-08-11T16:30:07Z")

</div>

Hi,  
Creating a userSource using the auto mode results in the tables depicted in the figure below:

 ![Screenshot 2024-08-11 191142](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/9/59ffc817f695c2974f63579cea61ee70036eff7c.png)

1. What is a simple way of modifying user\_ex and user\_sa tables
2. The table named \<auth\_user\_sa\> seems to contain columns that help in tracking user activity. I'd like to know whether: start\_date and end\_date refer, respectively, to the time a user has been registered/deleted OR is it a daily tracking of when a user loggedin/out?