In the last 3 years, the SQL Security team has put more emphasis on enabling customers to use SQL Server while adhering to the Principle of least Privilege (PolP). As part of that effort, all new fea...
Updated Dec 12, 2022
Version 7.0
Blog Post
9 MIN READ
New granular permissions for SQL Server 2022 and Azure SQL to improve adherence with PoLP
Yes, that is essentially best you can do with permissions for this script.
Alternatively, in cases when it's about only a few specific objects/scripts, one can also create stored procedures/functions/views with the required joined objects and then just grant execute/select on those specifically crafted modules.
(Basically, taking your script, adding CREATE PROCEDURE proc_name AS on top and then grant access to the proc only)