-- USE ManageSoft
USE RayVentory

DECLARE @Role NVARCHAR(128) = 'mgs_reader'

-- Inventory > HardwareOverview report
EXEC ('GRANT EXECUTE ON [dbo].[sp_HardwareOverview] to ' + @Role + ' AS [dbo]')

-- Inventory > Infrastructure report.  Only needed if upgraded from RVS 10.6
EXEC ('GRANT EXECUTE ON [dbo].[sp_rp_Infrastructure] to ' + @Role + ' AS [dbo]')

-- Inventory > General > InventoryFailure report
EXEC ('GRANT EXECUTE ON [dbo].[sp_rp_InventoryFailure] to ' + @Role + ' AS [dbo]')

-- Inventory > General > InventoryOverview report
EXEC ('GRANT EXECUTE ON [dbo].[sp_InventoryOverview] to ' + @Role + ' AS [dbo]')

-- SoftwareDeployment > LicenseCounting report
EXEC ('GRANT EXECUTE ON [dbo].[LicenseCounterGetLicensesCalculated] to ' + @Role + ' AS [dbo]')

-- SoftwareDeployment > SubReport > PackageInstallationFailureDetails report
EXEC ('GRANT EXECUTE ON [dbo].[OrganizationIdentifyDescendentsByOUDN] to ' + @Role + ' AS [dbo]')

-- Required for RayManageSoftWeb access only
EXEC ('GRANT EXECUTE ON [dbo].[ReportingGetAllGroups] to ' + @Role + ' AS [dbo]')
EXEC ('GRANT EXECUTE ON [dbo].[ReportingGetLinks] to ' + @Role + ' AS [dbo]')