Issue Summary

Too many TXs are being open when accessing plan dashboard as a regular user.

Symptom severity depends on DB type and DB server condition, i.e. PostgreSQL is known to handle the load better than MSSQL.

Steps to Reproduce

1. Open the plan dashboard as non-admin user

Expected Results

• AclService only opens TX if it needs to fetch data from the DB
• opening multiple TXs in a loop is avoided

Actual Results

AclService opens DB tx even if it doesn't need to fetch anything, multiple times

Workaround

Configure plan filter(s) in order to reduce amount of plans shown at the same time.