# SQL table breaking after leaving Designer

**URL:** <https://forum.inductiveautomation.com/t/sql-table-breaking-after-leaving-designer/39922>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [October 22, 2020, 2:59pm UTC](https://forum.inductiveautomation.com/t/sql-table-breaking-after-leaving-designer/39922 "2020-10-22T14:59:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![patrick.swain](https://avatars.discourse-cdn.com/v4/letter/p/c77e96/32.png) [@patrick.swain](https://forum.inductiveautomation.com/u/patrick.swain)\
**Post date:** [October 22, 2020, 2:59pm UTC](https://forum.inductiveautomation.com/t/sql-table-breaking-after-leaving-designer/39922/1 "2020-10-22T14:59:27Z")

</div>

I have a very simple SQL table logging 2 variables from a PLC. I can view the table and all of the data looks good. I want to be able to query the SQL server to return these values into a table. In the Designer, the preview shows all of the data perfectly. When the project is launched, the table is shown as a broken link. The table “data” was bound to the DB using “DB browse” and for the sake of troubleshooting, only default settings on this table exist.

I’m hoping there’s something silly that I’m not considering?!

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/6/b6bcdb3d792e34601002131a3763d16880bed03a.png)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [October 22, 2020, 3:01pm UTC](https://forum.inductiveautomation.com/t/sql-table-breaking-after-leaving-designer/39922/2 "2020-10-22T15:01:59Z")

</div>

> [@ERROR(500): Error executing function 'RunQuery': The current user does not have the required roles for this operation](http://forum.inductiveautomation.com/t/error-500-error-executing-function-runquery-the-current-user-does-not-have-the-required-roles-for-this-operation/15252/4):
>
> As of Ignition 7.9.4 there’s a new set of client scoped permissions that prevent even authenticated clients, by default, from changing anything on the gateway. [https://docs.inductiveautomation.com/display/DOC79/Project+Properties#ProjectProperties-ClientPermissions](https://docs.inductiveautomation.com/display/DOC79/Project+Properties#ProjectProperties-ClientPermissions)

---

<div class="post-metadata">

**Author:** ![patrick.swain](https://avatars.discourse-cdn.com/v4/letter/p/c77e96/32.png) [@patrick.swain](https://forum.inductiveautomation.com/u/patrick.swain)\
**Post date:** [October 22, 2020, 3:44pm UTC](https://forum.inductiveautomation.com/t/sql-table-breaking-after-leaving-designer/39922/3 "2020-10-22T15:44:29Z")

</div>

Great. Thanks, PGriffith!