Alternative of Terraform for Data transformer to give an access to dataset

Hi everyone!
Our DE team wants to find a better tool to give to the data transformer (e.g. analytics engineers, PAs) to grant access to some datasets. Example, I have created a transformation and at the end have an aggregated data that is joined from more than 2 different tables. It is kind of not a semantic table any more, rather than my own table. How can I, independently of DE team grant a query-only access to it t the data consumers? The first thing that comes to mind is Terraform. But it is too complicated. Any suggestions here. We are using dbt core.