The seventh SQL view in this series does not include users, but instead shows the tasks and the operations. To use this view you will need to have populated the Security Resource Descriptions table.
CREATE VIEW [dbo].[uv_AZRCRV_SecurityTasksWithOperations] AS
/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (https://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 2.0 UK: England & Wales (CC BY-NC-SA 2.0 UK).
*/
SELECT
['Security Task Master'].SECURITYTASKID AS 'Security Task ID'
,['Security Task Master'].SECURITYTASKNAME AS 'Security Task Name'
,['Security Task Master'].SECURITYTASKDESC AS 'Security Task Description'
,['Security Resource Descriptions'].PRODNAME AS 'Product Name'
,['Security Resource Descriptions'].Series_Name AS 'Series Name'
,['Security Resource Descriptions'].DSPLNAME AS 'Security Operation Name'
,['Security Resource Descriptions'].TYPESTR AS 'Security Operation Type'
FROM
SY09000 AS ['Security Task Master']
INNER JOIN
SY10700 AS ['Security Assignment Task Operations']
ON
['Security Assignment Task Operations'].SECURITYTASKID = ['Security Task Master'].SECURITYTASKID
INNER JOIN
SY09400 AS ['Security Resource Descriptions']
ON
['Security Resource Descriptions'].SECURITYID = ['Security Assignment Task Operations'].SECURITYID
AND
['Security Resource Descriptions'].DICTID = ['Security Assignment Task Operations'].DICTID
GO
GRANT SELECT ON uv_AZRCRV_SecurityTasksWithOperations TO DYNGRP
GO
