Database Problems when lunching the project

[v.fernando1331]

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

[PGriffith]

ERROR(500): Error executing function 'RunQuery': The current user does not have the required roles for this operation

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

[v.fernando1331]

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

btw thanks for the replay

[PGriffith]

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.

[v.fernando1331]

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