hi 🙂 what permissions are needed on the role to do below queries?

select * from transaction

select * from transactionline

Admin

Well you don't need an admin role, but if you don't use an admin role, then the results will be limited by the transactions that your role has access to