# User Source Table-Authentication Error

**URL:** <https://forum.inductiveautomation.com/t/user-source-table-authentication-error/67048>\
**Category:** Ignition\
**Tags:** database, ignition80, perspective\
**Created:** [November 29, 2022, 7:25pm UTC](https://forum.inductiveautomation.com/t/user-source-table-authentication-error/67048 "2022-11-29T19:25:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Goutham\_Rao\_Y](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@Goutham\_Rao\_Y](https://forum.inductiveautomation.com/u/Goutham_Rao_Y)\
**Post date:** [November 29, 2022, 7:25pm UTC](https://forum.inductiveautomation.com/t/user-source-table-authentication-error/67048/1 "2022-11-29T19:25:17Z")

</div>

Hello Team,  
I need your help to tackle the following problem.

Database used: **MSSQL** server  
Module: Perspective

When I tried to rename the column [belonging to login authentication table] with a new name, the column updates properly, but when i tried to login after the column was renamed, the login failed.

-\> screenshots:  
**Authentication Table:**  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/1/a129ea4fe6a63e205f553d4348f27dffafcc69cb.png)

**Before renaming the column**  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/f/4fb895d018d07555d32f4bba36ac60148dc9f1fd.png)  
**Able to Login successfully**

**After renaming the column**  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/5/c59681ac4fa267e6c7f63ee313895bddd01041c4.png)

After renaming when i try to login, i get **authentication error**  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/8/f8286f589eb8cd619c0ad28fad209c5742c6f550.png)  
Even though **username** and **password** exist in the database table. I am not able to login.

Is there anything else I need to change/update [ex: gateway...etc.] to overcome this authentication issue?

Thanks in Advance,

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [November 29, 2022, 7:27pm UTC](https://forum.inductiveautomation.com/t/user-source-table-authentication-error/67048/2 "2022-11-29T19:27:27Z")

</div>

Perhaps this is obvious and I'm just out in left field, but why would you expect it to work after you changed the Schema of the table? Why would you even need to change it?

I wouldn't expect it to work until you change it back.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [November 29, 2022, 7:27pm UTC](https://forum.inductiveautomation.com/t/user-source-table-authentication-error/67048/3 "2022-11-29T19:27:41Z")

</div>

Don't change the column name. If you need it in that format, use a SQL View.

---

<div class="post-metadata">

**Author:** ![Goutham\_Rao\_Y](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@Goutham\_Rao\_Y](https://forum.inductiveautomation.com/u/Goutham_Rao_Y)\
**Post date:** [December 1, 2022, 4:59am UTC](https://forum.inductiveautomation.com/t/user-source-table-authentication-error/67048/4 "2022-12-01T04:59:39Z")

</div>

@pturmel  
\*\*found a temporary solution: \*\*  
After making changes to the DB table, you have to go back to the Gateway \> User, Roles section. Find the DB User Source you are using and click on “edit” and simply “save changes”. To confirm that all the users are loaded, you can click on your User Source \> “manage users” and it should show a list of all users from your DB table.