Query Data Model security

Summary

Example of query or config to allow data models be displayed to all employees without them seeing whole company data.

Content

Hello all

When a more robust report is needed we usually configure a DATA MODEL and then a query using the information as required.
It works fine if is a user with access to all employees will be seing the report.
BUT the problem is .. we would like to let others to access it as well.

IS  there a query like example or a way to configure this report security:

HR -> Can see all
MANAGER -> Sees himself and tem