Hi

We are implementing Cloud this year and have a requirement from our HR team to use the Query Designer to build their own adhoc custom reports and queries for day-to-day HR Operations.

We are not sure how we can set up the correct security and permissions for them. 

Is there a way to restrict access in the query designer so that they would be able to build their own queries from the HR tables and never see any queries used / built by other teams such as Finance? 

They should only access to build and use their own custom queries. 

Any help or ideas would be much appreciated!

Thanks.