test: add test for checking vtables access

Summary

This is a test for sbroad!448 (merged)

Originally, when executing queries involving Motions we have to deal with virtual tables, capturing Motion's data. We need to create them and then read from them. The problem was that we had to grant those access privileges to user executing such a query (in case it's not an admin).

Granting such privileges on each vtable interaction seems to have a big overhead so that solution being made in corresponding sbroad MR is to execute queries by admin.

---

• Close #620 (closed)
• Follow-up for sbroad!448 (merged)
• Cherry-pick to: 24.2 and 24.3
• Docs follow-up: not necessary