# Permission restriction using system.db.runPrepQuery in component event script

**URL:** <https://forum.inductiveautomation.com/t/permission-restriction-using-system-db-runprepquery-in-component-event-script/87183>\
**Category:** Ignition\
**Tags:** ignition81, scripting, vision\
**Created:** [March 12, 2024, 2:33pm UTC](https://forum.inductiveautomation.com/t/permission-restriction-using-system-db-runprepquery-in-component-event-script/87183 "2024-03-12T14:33:52Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Om33](https://avatars.discourse-cdn.com/v4/letter/o/7ba0ec/32.png) [@Om33](https://forum.inductiveautomation.com/u/Om33)\
**Post date:** [March 12, 2024, 2:33pm UTC](https://forum.inductiveautomation.com/t/permission-restriction-using-system-db-runprepquery-in-component-event-script/87183/1 "2024-03-12T14:33:52Z")

</div>

Hello,  
I' m getting the error below due to this line in my component event script: `result = system.db.runPrepQuery("SELECT DISTINCT id FROM Stoermeldungen_10713 WHERE t_stamp BETWEEN ? AND ?", [start, ende])`

```auto
Traceback (most recent call last):
  File "<event:propertyChange>", line 23, in <module>
java.lang.Exception: java.lang.Exception: Error executing system.db.runPrepQuery(SELECT DISTINCT id FROM Stoermeldungen_10713 WHERE t_stamp BETWEEN ? AND ?, , [Mon Mar 11 06:00:00 CET 2024, Tue Mar 12 06:00:00 CET 2024], )

	caused by Exception: Error executing system.db.runPrepQuery(SELECT DISTINCT id FROM Stoermeldungen_10713 WHERE t_stamp BETWEEN ? AND ?, , [Mon Mar 11 06:00:00 CET 2024, Tue Mar 12 06:00:00 CET 2024], )
	caused by GatewayException: Error executing function 'RunQuery': The current user does not have the required roles for this operation.
	caused by GatewayFunctionException: The current user does not have the required roles for this operation.

Ignition v8.1.27 (b2023042509)
Java: Azul Systems, Inc. 11.0.18

```

I have an administrator permission and I don't encounter this problem when I use this function in the script console

---

<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:** [March 12, 2024, 2:35pm UTC](https://forum.inductiveautomation.com/t/permission-restriction-using-system-db-runprepquery-in-component-event-script/87183/2 "2024-03-12T14:35:45Z")

</div>

Look in the Vision security section of your project properties. This would be Legacy DB access.

---

<div class="post-metadata">

**Author:** ![Om33](https://avatars.discourse-cdn.com/v4/letter/o/7ba0ec/32.png) [@Om33](https://forum.inductiveautomation.com/u/Om33)\
**Post date:** [March 12, 2024, 2:47pm UTC](https://forum.inductiveautomation.com/t/permission-restriction-using-system-db-runprepquery-in-component-event-script/87183/3 "2024-03-12T14:47:25Z")

</div>

It looks like this:

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

---

<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:** [March 12, 2024, 3:10pm UTC](https://forum.inductiveautomation.com/t/permission-restriction-using-system-db-runprepquery-in-component-event-script/87183/4 "2024-03-12T15:10:15Z")

</div>

Are you logged into the designer (or Vision Client) with a user that has the Administrator role?

---

<div class="post-metadata">

**Author:** ![Om33](https://avatars.discourse-cdn.com/v4/letter/o/7ba0ec/32.png) [@Om33](https://forum.inductiveautomation.com/u/Om33)\
**Post date:** [March 12, 2024, 3:20pm UTC](https://forum.inductiveautomation.com/t/permission-restriction-using-system-db-runprepquery-in-component-event-script/87183/5 "2024-03-12T15:20:35Z")

</div>

Yes

---

<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:** [March 12, 2024, 3:21pm UTC](https://forum.inductiveautomation.com/t/permission-restriction-using-system-db-runprepquery-in-component-event-script/87183/6 "2024-03-12T15:21:12Z")

</div>

Look for typos, extra spaces. Also, log out and log back in if the role change was recent.

---

<div class="post-metadata">

**Author:** ![Om33](https://avatars.discourse-cdn.com/v4/letter/o/7ba0ec/32.png) [@Om33](https://forum.inductiveautomation.com/u/Om33)\
**Post date:** [March 13, 2024, 10:05am UTC](https://forum.inductiveautomation.com/t/permission-restriction-using-system-db-runprepquery-in-component-event-script/87183/7 "2024-03-13T10:05:51Z")

</div>

I finally let this field empty and it works now:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/2/92f80349dc14bd5b9cf70dc9f2d6afbbe24ab2d9.png)

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [March 13, 2024, 1:15pm UTC](https://forum.inductiveautomation.com/t/permission-restriction-using-system-db-runprepquery-in-component-event-script/87183/8 "2024-03-13T13:15:03Z")

</div>

That would imply you were not logged in as administrator.