You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server.

[!INCLUDE SQL Server Azure SQL Database Synapse Analytics PDW]. Every [!INCLUDE ssNoVersion] securable has associated permissions that can be granted to a principal.Permissions in the [!INCLUDE ssDE] ...

Simply run the permissions-manager-install.sql file, specifying which database you want the objects to be created in, and then schedule either the perms.createSnapshot (for a specific database) or ...