Run Query required roles

Ignition
, ,
1

Hi,

After update from 7.9 to 8.0.16 I have the error below in my main project :

ERROR(500): Error executing function 'RunQuery': The current user does not have the required roles for this operation.
Client permission denied for user admin: key=legacy-db

So my client tag can't run an SQL query.
Can you help me ? Is there any configuration to do in gateway ?

Thanks,

2

Look in your project's security properties and enable legacy database access.

2 Likes
3

Phil’s answer is correct, but I find the error a bit odd - this should only be an issue for new projects since Ignition 7.9.4. Existing projects from before 7.9.4 should have legacy database access by default.

4

Thanks for your help. It works.