Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Rich LaMarche]

Up

0

Down

::

If you have the ability to run SQL which it sounds like you do, I use the following query based on the window display name to return all of the things that have access to that window. I pasted it below as text as I figured it might be easier to deal with than an attachment.

--The following query is used to display security roles and security tasks that are associated with a specific window 
--or with a specific report. You can specify the window or the report by changing the display name in the last line of 
--the query.

SELECT ISNULL(A.SECURITYROLEID, '') AS   SECURITYROLEID
     , ISNULL(M.SECURITYROLENAME, '') AS SECURITYROLENAME
     , ISNULL(O.SECURITYTASKID, '') AS   SECURITYTASKID
     , ISNULL(T.SECURITYTASKNAME, '') AS SECURITYTASKNAME
     , R.PRODNAME
     , R.TYPESTR
     , R.DSPLNAME
     , R.RESTECHNAME
     , R.DICTID
     , R.SECRESTYPE
     , R.SECURITYID
  FROM DYNAMICS.dbo.SY09400 R
       FULL JOIN DYNAMICS.dbo.SY10700 O
         ON R.DICTID = O.DICTID
            AND O.SECRESTYPE = R.SECRESTYPE
            AND O.SECURITYID = R.SECURITYID
       FULL JOIN DYNAMICS.dbo.SY09000 T
         ON T.SECURITYTASKID = O.SECURITYTASKID
       FULL JOIN DYNAMICS.dbo.SY10600 A
         ON A.SECURITYTASKID = T.SECURITYTASKID
       FULL JOIN DYNAMICS.dbo.SY09100 M
         ON M.SECURITYROLEID = A.SECURITYROLEID
--WHERE R.DSPLNAME = 'User Setup'
--WHERE R.DSPLNAME = 'Customer Maintenance Options'
--WHERE R.DSPLNAME = 'FS-Meter Master'
--WHERE R.DSPLNAME = 'Garnishment Maximum Setup'
WHERE R.DSPLNAME = 'Purchase Order inquiry zoom'
--WHERE R.DSPLNAME IN ( 'Budget Import Exception Report')
--where prodname = 'Excel-Based Budgeting'
--where R.RESTECHNAME = 'UM_Maintenance_Group_Schedule_lookup'
--where r.TYPESTR = 'SmartList Objects'
--      and r.DSPLNAME like '%purchase requisitions%'
order by 1