# Database Problems when lunching the project

**URL:** <https://forum.inductiveautomation.com/t/database-problems-when-lunching-the-project/23653>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [March 27, 2019, 4:23pm UTC](https://forum.inductiveautomation.com/t/database-problems-when-lunching-the-project/23653 "2019-03-27T16:23:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![v.fernando1331](https://avatars.discourse-cdn.com/v4/letter/v/a4c791/32.png) [@v.fernando1331](https://forum.inductiveautomation.com/u/v.fernando1331)\
**Post date:** [March 27, 2019, 4:23pm UTC](https://forum.inductiveautomation.com/t/database-problems-when-lunching-the-project/23653/1 "2019-03-27T16:23:14Z")

</div>

I can use and manipulate databases on the designer, but when I lunch the project it looks like this:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/508027646b14b166d5a93eb812f23d8b1a20fcf3.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:** [March 27, 2019, 4:25pm UTC](https://forum.inductiveautomation.com/t/database-problems-when-lunching-the-project/23653/2 "2019-03-27T16:25:18Z")

</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:** ![v.fernando1331](https://avatars.discourse-cdn.com/v4/letter/v/a4c791/32.png) [@v.fernando1331](https://forum.inductiveautomation.com/u/v.fernando1331)\
**Post date:** [March 27, 2019, 4:39pm UTC](https://forum.inductiveautomation.com/t/database-problems-when-lunching-the-project/23653/3 "2019-03-27T16:39:08Z")

</div>

So I need to create a new security zone or modify the service security?

btw thanks for the replay

---

<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:** [March 27, 2019, 4:49pm UTC](https://forum.inductiveautomation.com/t/database-problems-when-lunching-the-project/23653/4 "2019-03-27T16:49:25Z")

</div>

The easy (bad) solution: Just change the client permissions in the project properties to allow ‘legacy database access’  
The better solution: Convert your DB calls to use named queries, which closes a security vulnerability in the client.

---

<div class="post-metadata">

**Author:** ![v.fernando1331](https://avatars.discourse-cdn.com/v4/letter/v/a4c791/32.png) [@v.fernando1331](https://forum.inductiveautomation.com/u/v.fernando1331)\
**Post date:** [March 27, 2019, 5:32pm UTC](https://forum.inductiveautomation.com/t/database-problems-when-lunching-the-project/23653/5 "2019-03-27T17:32:19Z")

</div>

The first solution worked. When we implement the project i will change it.