A little more information. To find security information for a Window, use the steps below:
1. Click Microsoft Dynamics GP, point to Maintenance, and then click Clear Data to open the Clear Data window.
2. On the Display menu, click Physical.
3. In the Series list, click System.
4. In the Tables pane, click the Security Resource Descriptions table, and then click Insert.
5. Click OK.
6. Click Yes.
7. In the Report Destination window, select the Screen check box, and then click OK to send the report to the screen.
8. Close the report.
After you have completed the steps above, open SQL and run the following SQL script:
SELECT ISNULL(A.SECURITYROLEID,'') AS SECURITYROLEID,
ISNULL(M.SECURITYROLENAME,'') AS SECURITYROLENAME,
--ISNULL(M.SECURITYROLEDESC,'') AS SECURITYROLEDESC,
ISNULL(O.SECURITYTASKID,'') AS SECURITYTASKID,
ISNULL(T.SECURITYTASKNAME,'') AS SECURITYTASKNAME,
--ISNULL(T.SECURITYTASKDESC,'') AS SECURITYTASKDESC,
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 = '<Display_Name>' -- Change this to be the name of the window
